1# SOME DESCRIPTIVE TITLE. 2# 3# Translators: 4msgid "" 5msgstr "" 6"Project-Id-Version: PostGIS\n" 7"Report-Msgid-Bugs-To: http://bugs.kde.org\n" 8"POT-Creation-Date: 2017-09-14 18:44+0000\n" 9"PO-Revision-Date: 2017-04-26 02:01+0000\n" 10"Last-Translator: TERAMOTO Ikuhiro <yellow@affrc.go.jp>\n" 11"Language-Team: Japanese (http://www.transifex.com/postgis/postgis/language/" 12"ja/)\n" 13"Language: ja\n" 14"MIME-Version: 1.0\n" 15"Content-Type: text/plain; charset=UTF-8\n" 16"Content-Transfer-Encoding: 8bit\n" 17"Plural-Forms: nplurals=1; plural=0;\n" 18 19#. Tag: title 20#: reference_operator.xml:3 21#, no-c-format 22msgid "Operators" 23msgstr "演算子" 24 25#. Tag: refname 26#: reference_operator.xml:6 27#, no-c-format 28msgid "&&" 29msgstr "&&" 30 31#. Tag: refpurpose 32#: reference_operator.xml:8 33#, no-c-format 34msgid "" 35"Returns <varname>TRUE</varname> if A's 2D bounding box intersects B's 2D " 36"bounding box." 37msgstr "" 38"Aの2次元バウンディングボックスがBの2次元バウンディングボックスとインタセクト" 39"する場合に<varname>TRUE</varname>を返します。" 40 41#. Tag: funcsynopsis 42#: reference_operator.xml:12 43#, no-c-format 44msgid "" 45"<funcprototype> <funcdef>boolean <function>&&</function></funcdef> " 46"<paramdef> <type>geometry </type> <parameter>A</parameter> </paramdef> " 47"<paramdef> <type>geometry </type> <parameter>B</parameter> </paramdef> </" 48"funcprototype> <funcprototype> <funcdef>boolean <function>&&</" 49"function></funcdef> <paramdef> <type>geography </type> <parameter>A</" 50"parameter> </paramdef> <paramdef> <type>geography </type> <parameter>B</" 51"parameter> </paramdef> </funcprototype>" 52msgstr "" 53"<funcprototype> <funcdef>boolean <function>&&</function></funcdef> " 54"<paramdef> <type>geometry </type> <parameter>A</parameter> </paramdef> " 55"<paramdef> <type>geometry </type> <parameter>B</parameter> </paramdef> </" 56"funcprototype> <funcprototype> <funcdef>boolean <function>&&</" 57"function></funcdef> <paramdef> <type>geography </type> <parameter>A</" 58"parameter> </paramdef> <paramdef> <type>geography </type> <parameter>B</" 59"parameter> </paramdef> </funcprototype>" 60 61#. Tag: title 62#: reference_operator.xml:50 reference_operator.xml:111 63#: reference_operator.xml:172 reference_operator.xml:233 64#: reference_operator.xml:294 reference_operator.xml:356 65#: reference_operator.xml:413 reference_operator.xml:470 66#: reference_operator.xml:530 reference_operator.xml:588 67#: reference_operator.xml:649 reference_operator.xml:707 68#: reference_operator.xml:760 reference_operator.xml:830 69#: reference_operator.xml:902 reference_operator.xml:955 70#: reference_operator.xml:1007 reference_operator.xml:1068 71#: reference_operator.xml:1129 reference_operator.xml:1193 72#: reference_operator.xml:1251 reference_operator.xml:1304 73#: reference_operator.xml:1354 reference_operator.xml:1415 74#: reference_operator.xml:1476 reference_operator.xml:1540 75#: reference_operator.xml:1619 reference_operator.xml:1694 76#: reference_operator.xml:1755 reference_operator.xml:1809 77#: reference_operator.xml:1874 78#, no-c-format 79msgid "Description" 80msgstr "説明" 81 82#. Tag: para 83#: reference_operator.xml:52 84#, no-c-format 85msgid "" 86"The <varname>&&</varname> operator returns <varname>TRUE</varname> " 87"if the 2D bounding box of geometry A intersects the 2D bounding box of " 88"geometry B." 89msgstr "" 90"<varname>&&</varname>演算子は、Aの2次元バウンディングボックスがBの2次" 91"元バウンディングボックスとインタセクトする場合に<varname>TRUE</varname>を返し" 92"ます。" 93 94#. Tag: para 95#: reference_operator.xml:54 reference_operator.xml:298 96#: reference_operator.xml:536 reference_operator.xml:597 97#: reference_operator.xml:655 reference_operator.xml:712 98#: reference_operator.xml:765 reference_operator.xml:907 99#: reference_operator.xml:961 reference_operator.xml:1199 100#: reference_operator.xml:1256 reference_operator.xml:1309 101#: reference_operator.xml:1545 102#, no-c-format 103msgid "" 104"This operand will make use of any indexes that may be available on the " 105"geometries." 106msgstr "これのオペランドは、ジオメトリで使用できるインデクスを使用します。" 107 108#. Tag: para 109#: reference_operator.xml:57 110#, no-c-format 111msgid "Enhanced: 2.0.0 support for Polyhedral surfaces was introduced." 112msgstr "Enhanced: 2.0.0 多面体サーフェス対応が導入されました。" 113 114#. Tag: para 115#: reference_operator.xml:58 116#, no-c-format 117msgid "Availability: 1.5.0 support for geography was introduced." 118msgstr "Availability: 1.5.0 ジオグラフィ対応が導入されました。" 119 120#. Tag: para 121#: reference_operator.xml:59 reference_operator.xml:119 122#: reference_operator.xml:180 reference_operator.xml:241 123#: reference_operator.xml:302 reference_operator.xml:364 124#: reference_operator.xml:421 reference_operator.xml:478 125#: reference_operator.xml:594 reference_operator.xml:852 126#: reference_operator.xml:1015 reference_operator.xml:1076 127#: reference_operator.xml:1137 reference_operator.xml:1362 128#: reference_operator.xml:1423 reference_operator.xml:1484 129#, no-c-format 130msgid "&curve_support;" 131msgstr "&curve_support;" 132 133#. Tag: para 134#: reference_operator.xml:60 reference_operator.xml:120 135#: reference_operator.xml:181 reference_operator.xml:242 136#: reference_operator.xml:303 reference_operator.xml:365 137#: reference_operator.xml:422 reference_operator.xml:479 138#: reference_operator.xml:595 reference_operator.xml:853 139#: reference_operator.xml:1016 reference_operator.xml:1077 140#: reference_operator.xml:1138 reference_operator.xml:1363 141#: reference_operator.xml:1424 reference_operator.xml:1485 142#: reference_operator.xml:1549 143#, no-c-format 144msgid "&P_support;" 145msgstr "&P_support;" 146 147#. Tag: title 148#: reference_operator.xml:64 reference_operator.xml:124 149#: reference_operator.xml:185 reference_operator.xml:246 150#: reference_operator.xml:371 reference_operator.xml:428 151#: reference_operator.xml:485 reference_operator.xml:541 152#: reference_operator.xml:602 reference_operator.xml:660 153#: reference_operator.xml:717 reference_operator.xml:770 154#: reference_operator.xml:858 reference_operator.xml:912 155#: reference_operator.xml:967 reference_operator.xml:1020 156#: reference_operator.xml:1081 reference_operator.xml:1142 157#: reference_operator.xml:1204 reference_operator.xml:1261 158#: reference_operator.xml:1314 reference_operator.xml:1367 159#: reference_operator.xml:1428 reference_operator.xml:1489 160#: reference_operator.xml:1564 reference_operator.xml:1642 161#: reference_operator.xml:1712 reference_operator.xml:1769 162#, no-c-format 163msgid "Examples" 164msgstr "例" 165 166#. Tag: programlisting 167#: reference_operator.xml:66 168#, no-c-format 169msgid "" 170"SELECT tbl1.column1, tbl2.column1, tbl1.column2 && tbl2.column2 AS " 171"overlaps\n" 172"FROM ( VALUES\n" 173" (1, 'LINESTRING(0 0, 3 3)'::geometry),\n" 174" (2, 'LINESTRING(0 1, 0 5)'::geometry)) AS tbl1,\n" 175"( VALUES\n" 176" (3, 'LINESTRING(1 2, 4 6)'::geometry)) AS tbl2;\n" 177"\n" 178" column1 | column1 | overlaps\n" 179"---------+---------+----------\n" 180" 1 | 3 | t\n" 181" 2 | 3 | f\n" 182"(2 rows)" 183msgstr "" 184"SELECT tbl1.column1, tbl2.column1, tbl1.column2 && tbl2.column2 AS " 185"overlaps\n" 186"FROM ( VALUES\n" 187" (1, 'LINESTRING(0 0, 3 3)'::geometry),\n" 188" (2, 'LINESTRING(0 1, 0 5)'::geometry)) AS tbl1,\n" 189"( VALUES\n" 190" (3, 'LINESTRING(1 2, 4 6)'::geometry)) AS tbl2;\n" 191"\n" 192" column1 | column1 | overlaps\n" 193"---------+---------+----------\n" 194" 1 | 3 | t\n" 195" 2 | 3 | f\n" 196"(2 rows)" 197 198#. Tag: title 199#: reference_operator.xml:71 reference_operator.xml:130 200#: reference_operator.xml:191 reference_operator.xml:252 201#: reference_operator.xml:322 reference_operator.xml:377 202#: reference_operator.xml:434 reference_operator.xml:491 203#: reference_operator.xml:547 reference_operator.xml:608 204#: reference_operator.xml:666 reference_operator.xml:723 205#: reference_operator.xml:776 reference_operator.xml:864 206#: reference_operator.xml:918 reference_operator.xml:973 207#: reference_operator.xml:1026 reference_operator.xml:1087 208#: reference_operator.xml:1148 reference_operator.xml:1210 209#: reference_operator.xml:1267 reference_operator.xml:1320 210#: reference_operator.xml:1373 reference_operator.xml:1434 211#: reference_operator.xml:1495 reference_operator.xml:1568 212#: reference_operator.xml:1658 reference_operator.xml:1716 213#: reference_operator.xml:1773 reference_operator.xml:1836 214#: reference_operator.xml:1892 215#, no-c-format 216msgid "See Also" 217msgstr "関連情報" 218 219#. Tag: para 220#: reference_operator.xml:73 221#, no-c-format 222msgid "" 223", <xref linkend=\"ST_Geometry_Overright\"/>, <xref linkend=" 224"\"ST_Geometry_Overbelow\"/>, <xref linkend=\"ST_Geometry_Overleft\"/>, <xref " 225"linkend=\"ST_Geometry_Contain\"/>, <xref linkend=\"ST_Geometry_Contained\"/>" 226msgstr "" 227", <xref linkend=\"ST_Geometry_Overright\"/>, <xref linkend=" 228"\"ST_Geometry_Overbelow\"/>, <xref linkend=\"ST_Geometry_Overleft\"/>, <xref " 229"linkend=\"ST_Geometry_Contain\"/>, <xref linkend=\"ST_Geometry_Contained\"/>" 230 231#. Tag: refname 232#: reference_operator.xml:85 233#, no-c-format 234msgid "&&(geometry,box2df)" 235msgstr "&&(geometry,box2df)" 236 237#. Tag: refpurpose 238#: reference_operator.xml:87 239#, no-c-format 240msgid "" 241"Returns <varname>TRUE</varname> if a geometry's (cached) 2D bounding box " 242"intersects a 2D float precision bounding box (BOX2DF)." 243msgstr "" 244"ジオメトリの (キャッシュされている)2次元バウンディングボックスが単精度浮動小" 245"数点数による2次元バウンディングボックスとインタセクトする場合に" 246"<varname>TRUE</varname>を返します。" 247 248#. Tag: funcprototype 249#: reference_operator.xml:92 250#, no-c-format 251msgid "" 252"<funcdef>boolean <function>&&</function></funcdef> <paramdef> " 253"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 254"<type>box2df</type> <parameter>B</parameter> </paramdef>" 255msgstr "" 256"<funcdef>boolean <function>&&</function></funcdef> <paramdef> " 257"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 258"<type>box2df</type> <parameter>B</parameter> </paramdef>" 259 260#. Tag: para 261#: reference_operator.xml:113 262#, no-c-format 263msgid "" 264"The <varname>&&</varname> operator returns <varname>TRUE</varname> " 265"if the cached 2D bounding box of geometry A intersects the 2D bounding box " 266"B, using float precision. This means that if B is a (double precision) " 267"box2d, it will be internally converted to a float precision 2D bounding box " 268"(BOX2DF)" 269msgstr "" 270"<varname>&&</varname>演算子は、ジオメトリAのキャッシュされた2次元バウ" 271"ンディングボックスが、2次元バウンディングボックスBとインタセクトする場合に、" 272"<varname>TRUE</varname>を返します。単精度浮動小数点数によるバウンディングボッ" 273"クスを使います。Bが倍精度浮動小数点数を使うbox2dである場合には、単精度浮動小" 274"数点数によるバウンディングボックス (BOX2DF)に変換されることになります。" 275 276#. Tag: para 277#: reference_operator.xml:115 reference_operator.xml:176 278#: reference_operator.xml:1011 reference_operator.xml:1072 279#: reference_operator.xml:1133 reference_operator.xml:1358 280#: reference_operator.xml:1419 reference_operator.xml:1480 281#, no-c-format 282msgid "" 283"This operand is intended to be used internally by BRIN indexes, more than by " 284"users." 285msgstr "" 286"この被演算子は、ユーザが使うためというよりも内部でBRINインデックスに使うため" 287"に導入されました。" 288 289#. Tag: para 290#: reference_operator.xml:118 reference_operator.xml:179 291#: reference_operator.xml:240 reference_operator.xml:363 292#: reference_operator.xml:420 reference_operator.xml:477 293#: reference_operator.xml:1014 reference_operator.xml:1075 294#: reference_operator.xml:1136 reference_operator.xml:1361 295#: reference_operator.xml:1422 reference_operator.xml:1483 296#, no-c-format 297msgid "" 298"Availability: 2.3.0 support for Block Range INdexes (BRIN) was introduced. " 299"Requires PostgreSQL 9.5+." 300msgstr "" 301"Availability: 2.3.0 BRIN (Block Range INdexes)が導入されました。PostgreSQL " 302"9.5以上が必要です。" 303 304#. Tag: programlisting 305#: reference_operator.xml:126 306#, no-c-format 307msgid "" 308"SELECT ST_MakePoint(1,1) && ST_MakeBox2D(ST_MakePoint(0,0), " 309"ST_MakePoint(2,2)) AS overlaps;\n" 310"\n" 311" overlaps\n" 312"----------\n" 313" t\n" 314"(1 row)" 315msgstr "" 316"SELECT ST_MakePoint(1,1) && ST_MakeBox2D(ST_MakePoint(0,0), " 317"ST_MakePoint(2,2)) AS overlaps;\n" 318"\n" 319" overlaps\n" 320"----------\n" 321" t\n" 322"(1 row)" 323 324#. Tag: para 325#: reference_operator.xml:132 reference_operator.xml:193 326#, no-c-format 327msgid "" 328", <xref linkend=\"overlaps_box2df_box2df\"/>, <xref linkend=" 329"\"contains_geometry_box2df\"/>, <xref linkend=\"contains_box2df_geometry\"/" 330">, <xref linkend=\"contains_box2df_box2df\"/>, <xref linkend=" 331"\"is_contained_geometry_box2df\"/>, <xref linkend=" 332"\"is_contained_box2df_geometry\"/>, <xref linkend=" 333"\"is_contained_box2df_box2df\"/>" 334msgstr "" 335", <xref linkend=\"overlaps_box2df_box2df\"/>, <xref linkend=" 336"\"contains_geometry_box2df\"/>, <xref linkend=\"contains_box2df_geometry\"/" 337">, <xref linkend=\"contains_box2df_box2df\"/>, <xref linkend=" 338"\"is_contained_geometry_box2df\"/>, <xref linkend=" 339"\"is_contained_box2df_geometry\"/>, <xref linkend=" 340"\"is_contained_box2df_box2df\"/>" 341 342#. Tag: refname 343#: reference_operator.xml:146 344#, no-c-format 345msgid "&&(box2df,geometry)" 346msgstr "&&(box2df,geometry)" 347 348#. Tag: refpurpose 349#: reference_operator.xml:148 350#, no-c-format 351msgid "" 352"Returns <varname>TRUE</varname> if a 2D float precision bounding box " 353"(BOX2DF) intersects a geometry's (cached) 2D bounding box." 354msgstr "" 355"単精度浮動小数点数による2次元バウンディングボックスがジオメトリの (キャッシュ" 356"されている)2次元バウンディングボックスとインタセクトする場合に<varname>TRUE</" 357"varname>を返します。" 358 359#. Tag: funcprototype 360#: reference_operator.xml:153 361#, no-c-format 362msgid "" 363"<funcdef>boolean <function>&&</function></funcdef> <paramdef> " 364"<type>box2df </type> <parameter>A</parameter> </paramdef> <paramdef> " 365"<type>geometry </type> <parameter>B</parameter> </paramdef>" 366msgstr "" 367"<funcdef>boolean <function>&&</function></funcdef> <paramdef> " 368"<type>box2df </type> <parameter>A</parameter> </paramdef> <paramdef> " 369"<type>geometry </type> <parameter>B</parameter> </paramdef>" 370 371#. Tag: para 372#: reference_operator.xml:174 373#, no-c-format 374msgid "" 375"The <varname>&&</varname> operator returns <varname>TRUE</varname> " 376"if the 2D bounding box A intersects the cached 2D bounding box of geometry " 377"B, using float precision. This means that if A is a (double precision) " 378"box2d, it will be internally converted to a float precision 2D bounding box " 379"(BOX2DF)" 380msgstr "" 381"<varname>&&</varname>演算子は、2次元バウンディングボックスAが、ジオメ" 382"トリBのキャッシュされた2次元バウンディングボックスとインタセクトする場合に、" 383"<varname>TRUE</varname>を返します。単精度浮動小数点数によるバウンディングボッ" 384"クスを使います。Aが倍精度浮動小数点数を使うbox2dである場合には、単精度浮動小" 385"数点数によるバウンディングボックス (BOX2DF)に変換されることになります。" 386 387#. Tag: programlisting 388#: reference_operator.xml:187 389#, no-c-format 390msgid "" 391"SELECT ST_MakeBox2D(ST_MakePoint(0,0), ST_MakePoint(2,2)) && " 392"ST_MakePoint(1,1) AS overlaps;\n" 393"\n" 394" overlaps\n" 395"----------\n" 396" t\n" 397"(1 row)" 398msgstr "" 399"SELECT ST_MakeBox2D(ST_MakePoint(0,0), ST_MakePoint(2,2)) && " 400"ST_MakePoint(1,1) AS overlaps;\n" 401"\n" 402" overlaps\n" 403"----------\n" 404" t\n" 405"(1 row)" 406 407#. Tag: refname 408#: reference_operator.xml:207 409#, no-c-format 410msgid "&&(box2df,box2df)" 411msgstr "&&(box2df,box2df)" 412 413#. Tag: refpurpose 414#: reference_operator.xml:209 415#, no-c-format 416msgid "" 417"Returns <varname>TRUE</varname> if two 2D float precision bounding boxes " 418"(BOX2DF) intersect each other." 419msgstr "" 420"二つの単精度浮動小数点数による2次元バウンディングボックス (BOX2DF)が相互にイ" 421"ンタセクトする場合に<varname>TRUE</varname>を返します。" 422 423#. Tag: funcprototype 424#: reference_operator.xml:214 425#, no-c-format 426msgid "" 427"<funcdef>boolean <function>&&</function></funcdef> <paramdef> " 428"<type>box2df </type> <parameter>A</parameter> </paramdef> <paramdef> " 429"<type>box2df </type> <parameter>B</parameter> </paramdef>" 430msgstr "" 431"<funcdef>boolean <function>&&</function></funcdef> <paramdef> " 432"<type>box2df </type> <parameter>A</parameter> </paramdef> <paramdef> " 433"<type>box2df </type> <parameter>B</parameter> </paramdef>" 434 435#. Tag: para 436#: reference_operator.xml:235 437#, no-c-format 438msgid "" 439"The <varname>&&</varname> operator returns <varname>TRUE</varname> " 440"if two 2D bounding boxes A and B intersect each other, using float " 441"precision. This means that if A (or B) is a (double precision) box2d, it " 442"will be internally converted to a float precision 2D bounding box (BOX2DF)" 443msgstr "" 444"<varname>&&</varname>演算子は、2次元バウンディングボックスAとBが相互" 445"にインタセクトする場合に、<varname>TRUE</varname>を返します。単精度浮動小数点" 446"数によるバウンディングボックスを使います。AまたはBが倍精度浮動小数点数を使う" 447"box2dである場合には、バウンディングボックス (BOX2DF)に変換されることになりま" 448"す。" 449 450#. Tag: para 451#: reference_operator.xml:237 reference_operator.xml:360 452#: reference_operator.xml:417 reference_operator.xml:474 453#, no-c-format 454msgid "" 455"This operator is intended to be used internally by BRIN indexes, more than " 456"by users." 457msgstr "" 458"この演算子は、ユーザが使うためというよりも内部でBRINインデックスに使うために" 459"導入されました。" 460 461#. Tag: programlisting 462#: reference_operator.xml:248 463#, no-c-format 464msgid "" 465"SELECT ST_MakeBox2D(ST_MakePoint(0,0), ST_MakePoint(2,2)) && " 466"ST_MakeBox2D(ST_MakePoint(1,1), ST_MakePoint(3,3)) AS overlaps;\n" 467"\n" 468" overlaps\n" 469"----------\n" 470" t\n" 471"(1 row)" 472msgstr "" 473"SELECT ST_MakeBox2D(ST_MakePoint(0,0), ST_MakePoint(2,2)) && " 474"ST_MakeBox2D(ST_MakePoint(1,1), ST_MakePoint(3,3)) AS overlaps;\n" 475"\n" 476" overlaps\n" 477"----------\n" 478" t\n" 479"(1 row)" 480 481#. Tag: para 482#: reference_operator.xml:254 483#, no-c-format 484msgid "" 485", <xref linkend=\"overlaps_box2df_geometry\"/>, <xref linkend=" 486"\"contains_geometry_box2df\"/>, <xref linkend=\"contains_box2df_geometry\"/" 487">, <xref linkend=\"contains_box2df_box2df\"/>, <xref linkend=" 488"\"is_contained_geometry_box2df\"/>, <xref linkend=" 489"\"is_contained_box2df_geometry\"/>, <xref linkend=" 490"\"is_contained_box2df_box2df\"/>" 491msgstr "" 492", <xref linkend=\"overlaps_box2df_geometry\"/>, <xref linkend=" 493"\"contains_geometry_box2df\"/>, <xref linkend=\"contains_box2df_geometry\"/" 494">, <xref linkend=\"contains_box2df_box2df\"/>, <xref linkend=" 495"\"is_contained_geometry_box2df\"/>, <xref linkend=" 496"\"is_contained_box2df_geometry\"/>, <xref linkend=" 497"\"is_contained_box2df_box2df\"/>" 498 499#. Tag: refname 500#: reference_operator.xml:268 501#, no-c-format 502msgid "&&&" 503msgstr "&&&" 504 505#. Tag: refpurpose 506#: reference_operator.xml:270 507#, no-c-format 508msgid "" 509"Returns <varname>TRUE</varname> if A's n-D bounding box intersects B's n-D " 510"bounding box." 511msgstr "" 512"Aのn次元バウンディングボックスがBのn次元バウンディングボックスとインタセクト" 513"する場合に<varname>TRUE</varname>を返します。" 514 515#. Tag: funcprototype 516#: reference_operator.xml:275 517#, no-c-format 518msgid "" 519"<funcdef>boolean <function>&&&</function></funcdef> <paramdef> " 520"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 521"<type>geometry </type> <parameter>B</parameter> </paramdef>" 522msgstr "" 523"<funcdef>boolean <function>&&&</function></funcdef> <paramdef> " 524"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 525"<type>geometry </type> <parameter>B</parameter> </paramdef>" 526 527#. Tag: para 528#: reference_operator.xml:296 529#, no-c-format 530msgid "" 531"The <varname>&&&</varname> operator returns <varname>TRUE</" 532"varname> if the n-D bounding box of geometry A intersects the n-D bounding " 533"box of geometry B." 534msgstr "" 535"<varname>&&&</varname>演算子は、Aのn次元バウンディングボックスがB" 536"のn次元バウンディングボックスとインタセクトする場合に<varname>TRUE</varname>" 537"を返します。" 538 539#. Tag: para 540#: reference_operator.xml:301 541#, no-c-format 542msgid "Availability: 2.0.0" 543msgstr "Availability: 2.0.0" 544 545#. Tag: para 546#: reference_operator.xml:304 reference_operator.xml:366 547#: reference_operator.xml:423 reference_operator.xml:480 548#, no-c-format 549msgid "&T_support;" 550msgstr "&T_support;" 551 552#. Tag: para 553#: reference_operator.xml:305 reference_operator.xml:367 554#: reference_operator.xml:424 reference_operator.xml:481 555#, no-c-format 556msgid "&Z_support;" 557msgstr "&Z_support;" 558 559#. Tag: title 560#: reference_operator.xml:309 561#, no-c-format 562msgid "Examples: 3D LineStrings" 563msgstr "例: 3次元ラインストリング" 564 565#. Tag: programlisting 566#: reference_operator.xml:311 567#, no-c-format 568msgid "" 569"SELECT tbl1.column1, tbl2.column1, tbl1.column2 &&& tbl2.column2 " 570"AS overlaps_3d,\n" 571" tbl1.column2 && tbl2.column2 AS " 572"overlaps_2d\n" 573"FROM ( VALUES\n" 574" (1, 'LINESTRING Z(0 0 1, 3 3 2)'::geometry),\n" 575" (2, 'LINESTRING Z(1 2 0, 0 5 -1)'::geometry)) AS tbl1,\n" 576"( VALUES\n" 577" (3, 'LINESTRING Z(1 2 1, 4 6 1)'::geometry)) AS tbl2;\n" 578"\n" 579" column1 | column1 | overlaps_3d | overlaps_2d\n" 580"---------+---------+-------------+-------------\n" 581" 1 | 3 | t | t\n" 582" 2 | 3 | f | t" 583msgstr "" 584"SELECT tbl1.column1, tbl2.column1, tbl1.column2 &&& tbl2.column2 " 585"AS overlaps_3d,\n" 586" tbl1.column2 && tbl2.column2 AS " 587"overlaps_2d\n" 588"FROM ( VALUES\n" 589" (1, 'LINESTRING Z(0 0 1, 3 3 2)'::geometry),\n" 590" (2, 'LINESTRING Z(1 2 0, 0 5 -1)'::geometry)) AS tbl1,\n" 591"( VALUES\n" 592" (3, 'LINESTRING Z(1 2 1, 4 6 1)'::geometry)) AS tbl2;\n" 593"\n" 594" column1 | column1 | overlaps_3d | overlaps_2d\n" 595"---------+---------+-------------+-------------\n" 596" 1 | 3 | t | t\n" 597" 2 | 3 | f | t" 598 599#. Tag: title 600#: reference_operator.xml:315 601#, no-c-format 602msgid "Examples: 3M LineStrings" 603msgstr "例: XYMラインストリング" 604 605#. Tag: programlisting 606#: reference_operator.xml:317 607#, no-c-format 608msgid "" 609"SELECT tbl1.column1, tbl2.column1, tbl1.column2 &&& tbl2.column2 " 610"AS overlaps_3zm,\n" 611" tbl1.column2 && tbl2.column2 AS " 612"overlaps_2d\n" 613"FROM ( VALUES\n" 614" (1, 'LINESTRING M(0 0 1, 3 3 2)'::geometry),\n" 615" (2, 'LINESTRING M(1 2 0, 0 5 -1)'::geometry)) AS tbl1,\n" 616"( VALUES\n" 617" (3, 'LINESTRING M(1 2 1, 4 6 1)'::geometry)) AS tbl2;\n" 618"\n" 619" column1 | column1 | overlaps_3zm | overlaps_2d\n" 620"---------+---------+-------------+-------------\n" 621" 1 | 3 | t | t\n" 622" 2 | 3 | f | t" 623msgstr "" 624"SELECT tbl1.column1, tbl2.column1, tbl1.column2 &&& tbl2.column2 " 625"AS overlaps_3zm,\n" 626" tbl1.column2 && tbl2.column2 AS " 627"overlaps_2d\n" 628"FROM ( VALUES\n" 629" (1, 'LINESTRING M(0 0 1, 3 3 2)'::geometry),\n" 630" (2, 'LINESTRING M(1 2 0, 0 5 -1)'::geometry)) AS tbl1,\n" 631"( VALUES\n" 632" (3, 'LINESTRING M(1 2 1, 4 6 1)'::geometry)) AS tbl2;\n" 633"\n" 634" column1 | column1 | overlaps_3zm | overlaps_2d\n" 635"---------+---------+-------------+-------------\n" 636" 1 | 3 | t | t\n" 637" 2 | 3 | f | t" 638 639#. Tag: refname 640#: reference_operator.xml:330 641#, no-c-format 642msgid "&&&(geometry,gidx)" 643msgstr "&&&(geometry,gidx)" 644 645#. Tag: refpurpose 646#: reference_operator.xml:332 647#, no-c-format 648msgid "" 649"Returns <varname>TRUE</varname> if a geometry's (cached) n-D bounding box " 650"intersects a n-D float precision bounding box (GIDX)." 651msgstr "" 652"ジオメトリの (キャッシュされている)n次元バウンディングボックスが単精度浮動小" 653"数点数によるn次元バウンディングボックス (GIDX)とインタセクトする場合に" 654"<varname>TRUE</varname>を返します。" 655 656#. Tag: funcprototype 657#: reference_operator.xml:337 658#, no-c-format 659msgid "" 660"<funcdef>boolean <function>&&&</function></funcdef> <paramdef> " 661"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 662"<type>gidx </type> <parameter>B</parameter> </paramdef>" 663msgstr "" 664"<funcdef>boolean <function>&&&</function></funcdef> <paramdef> " 665"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 666"<type>gidx </type> <parameter>B</parameter> </paramdef>" 667 668#. Tag: para 669#: reference_operator.xml:358 670#, no-c-format 671msgid "" 672"The <varname>&&&</varname> operator returns <varname>TRUE</" 673"varname> if the cached n-D bounding box of geometry A intersects the n-D " 674"bounding box B, using float precision. This means that if B is a (double " 675"precision) box3d, it will be internally converted to a float precision 3D " 676"bounding box (GIDX)" 677msgstr "" 678"<varname>&&&</varname>演算子は、ジオメトリAのキャッシュされたn次" 679"元バウンディングボックスが、n次元バウンディングボックスBとインタセクトする場" 680"合に、<varname>TRUE</varname>を返します。単精度浮動小数点数によるバウンディン" 681"グボックスを使います。Bが倍精度浮動小数点数を使うbox3dである場合には、単精度" 682"浮動小数点数による3次元バウンディングボックス (GIDX)に変換されることになりま" 683"す。" 684 685#. Tag: programlisting 686#: reference_operator.xml:373 687#, no-c-format 688msgid "" 689"SELECT ST_MakePoint(1,1,1) &&& ST_3DMakeBox(ST_MakePoint(0,0,0), " 690"ST_MakePoint(2,2,2)) AS overlaps;\n" 691"\n" 692" overlaps\n" 693"----------\n" 694" t\n" 695"(1 row)" 696msgstr "" 697"SELECT ST_MakePoint(1,1,1) &&& ST_3DMakeBox(ST_MakePoint(0,0,0), " 698"ST_MakePoint(2,2,2)) AS overlaps;\n" 699"\n" 700" overlaps\n" 701"----------\n" 702" t\n" 703"(1 row)" 704 705#. Tag: para 706#: reference_operator.xml:379 reference_operator.xml:436 707#, no-c-format 708msgid ", <xref linkend=\"overlaps_nd_gidx_gidx\"/>" 709msgstr ", <xref linkend=\"overlaps_nd_gidx_gidx\"/>" 710 711#. Tag: refname 712#: reference_operator.xml:387 713#, no-c-format 714msgid "&&&(gidx,geometry)" 715msgstr "&&&(gidx,geometry)" 716 717#. Tag: refpurpose 718#: reference_operator.xml:389 719#, no-c-format 720msgid "" 721"Returns <varname>TRUE</varname> if a n-D float precision bounding box (GIDX) " 722"intersects a geometry's (cached) n-D bounding box." 723msgstr "" 724"単精度浮動小数点数によるn次元バウンディングボックス (GIDX)がジオメトリの " 725"(キャッシュされている)n次元バウンディングボックスとインタセクトする場合に" 726"<varname>TRUE</varname>を返します。" 727 728#. Tag: funcprototype 729#: reference_operator.xml:394 730#, no-c-format 731msgid "" 732"<funcdef>boolean <function>&&&</function></funcdef> <paramdef> " 733"<type>gidx </type> <parameter>A</parameter> </paramdef> <paramdef> " 734"<type>geometry </type> <parameter>B</parameter> </paramdef>" 735msgstr "" 736"<funcdef>boolean <function>&&&</function></funcdef> <paramdef> " 737"<type>gidx </type> <parameter>A</parameter> </paramdef> <paramdef> " 738"<type>geometry </type> <parameter>B</parameter> </paramdef>" 739 740#. Tag: para 741#: reference_operator.xml:415 742#, no-c-format 743msgid "" 744"The <varname>&&&</varname> operator returns <varname>TRUE</" 745"varname> if the n-D bounding box A intersects the cached n-D bounding box of " 746"geometry B, using float precision. This means that if A is a (double " 747"precision) box3d, it will be internally converted to a float precision 3D " 748"bounding box (GIDX)" 749msgstr "" 750"<varname>&&&</varname>演算子は、n次元バウンディングボックスAが、" 751"ジオメトリBのキャッシュされたn次元バウンディングボックスとインタセクトする場" 752"合に、<varname>TRUE</varname>を返します。単精度浮動小数点数によるバウンディン" 753"グボックスを使います。Aが倍精度浮動小数点数を使うbox3dである場合には、単精度" 754"浮動小数点数による3次元バウンディングボックス (GIDX)に変換されることになりま" 755"す。" 756 757#. Tag: programlisting 758#: reference_operator.xml:430 759#, no-c-format 760msgid "" 761"SELECT ST_3DMakeBox(ST_MakePoint(0,0,0), ST_MakePoint(2,2,2)) &&" 762"& ST_MakePoint(1,1,1) AS overlaps;\n" 763"\n" 764" overlaps\n" 765"----------\n" 766" t\n" 767"(1 row)" 768msgstr "" 769"SELECT ST_3DMakeBox(ST_MakePoint(0,0,0), ST_MakePoint(2,2,2)) &&" 770"& ST_MakePoint(1,1,1) AS overlaps;\n" 771"\n" 772" overlaps\n" 773"----------\n" 774" t\n" 775"(1 row)" 776 777#. Tag: refname 778#: reference_operator.xml:444 779#, no-c-format 780msgid "&&&(gidx,gidx)" 781msgstr "&&&(gidx,gidx)" 782 783#. Tag: refpurpose 784#: reference_operator.xml:446 785#, no-c-format 786msgid "" 787"Returns <varname>TRUE</varname> if two n-D float precision bounding boxes " 788"(GIDX) intersect each other." 789msgstr "" 790"二つの単精度浮動小数点数によるn次元バウンディングボックス (GIDX)が相互にイン" 791"タセクトする場合に<varname>TRUE</varname>を返します。" 792 793#. Tag: funcprototype 794#: reference_operator.xml:451 795#, no-c-format 796msgid "" 797"<funcdef>boolean <function>&&&</function></funcdef> <paramdef> " 798"<type>gidx </type> <parameter>A</parameter> </paramdef> <paramdef> " 799"<type>gidx </type> <parameter>B</parameter> </paramdef>" 800msgstr "" 801"<funcdef>boolean <function>&&&</function></funcdef> <paramdef> " 802"<type>gidx </type> <parameter>A</parameter> </paramdef> <paramdef> " 803"<type>gidx </type> <parameter>B</parameter> </paramdef>" 804 805#. Tag: para 806#: reference_operator.xml:472 807#, no-c-format 808msgid "" 809"The <varname>&&&</varname> operator returns <varname>TRUE</" 810"varname> if two n-D bounding boxes A and B intersect each other, using float " 811"precision. This means that if A (or B) is a (double precision) box3d, it " 812"will be internally converted to a float precision 3D bounding box (GIDX)" 813msgstr "" 814"<varname>&&&</varname>演算子は、n次元バウンディングボックスAとBが" 815"相互にインタセクトする場合に、<varname>TRUE</varname>を返します。単精度浮動小" 816"数点数によるバウンディングボックスを使います。AまたはBが倍精度浮動小数点数を" 817"使うbox3dである場合には、単精度浮動小数点数による3次元バウンディングボックス " 818"(GIDX)に変換されることになります。" 819 820#. Tag: programlisting 821#: reference_operator.xml:487 822#, no-c-format 823msgid "" 824"SELECT ST_3DMakeBox(ST_MakePoint(0,0,0), ST_MakePoint(2,2,2)) &&" 825"& ST_3DMakeBox(ST_MakePoint(1,1,1), ST_MakePoint(3,3,3)) AS overlaps;\n" 826"\n" 827" overlaps\n" 828"----------\n" 829" t\n" 830"(1 row)" 831msgstr "" 832"SELECT ST_3DMakeBox(ST_MakePoint(0,0,0), ST_MakePoint(2,2,2)) &&" 833"& ST_3DMakeBox(ST_MakePoint(1,1,1), ST_MakePoint(3,3,3)) AS overlaps;\n" 834"\n" 835" overlaps\n" 836"----------\n" 837" t\n" 838"(1 row)" 839 840#. Tag: para 841#: reference_operator.xml:493 842#, no-c-format 843msgid ", <xref linkend=\"overlaps_nd_gidx_geometry\"/>" 844msgstr ", <xref linkend=\"overlaps_nd_gidx_geometry\"/>" 845 846#. Tag: refname 847#: reference_operator.xml:501 848#, no-c-format 849msgid "&<" 850msgstr "&<" 851 852#. Tag: refpurpose 853#: reference_operator.xml:503 854#, no-c-format 855msgid "" 856"Returns <varname>TRUE</varname> if A's bounding box overlaps or is to the " 857"left of B's." 858msgstr "" 859"AのバウンディングボックスがBのバウンディングボックスをオーバラップするか、Bの" 860"バウンディングボックスの左にある場合に<varname>TRUE</varname>を返します。" 861 862#. Tag: funcprototype 863#: reference_operator.xml:508 864#, no-c-format 865msgid "" 866"<funcdef>boolean <function>&<</function></funcdef> <paramdef> " 867"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 868"<type>geometry </type> <parameter>B</parameter> </paramdef>" 869msgstr "" 870"<funcdef>boolean <function>&<</function></funcdef> <paramdef> " 871"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 872"<type>geometry </type> <parameter>B</parameter> </paramdef>" 873 874#. Tag: para 875#: reference_operator.xml:532 876#, no-c-format 877msgid "" 878"The <varname>&<</varname> operator returns <varname>TRUE</varname> if " 879"the bounding box of geometry A overlaps or is to the left of the bounding " 880"box of geometry B, or more accurately, overlaps or is NOT to the right of " 881"the bounding box of geometry B." 882msgstr "" 883"<varname>&<</varname>演算子は、AのバウンディングボックスがBのバウン" 884"ディングボックスをオーバラップするか、Bのバウンディングボックスの左にある場合" 885"に<varname>TRUE</varname>を返します。条件についてより詳細に言うと、Bのバウン" 886"ディングボックスをオーバラップするかBのバウンディングボックスの右に*ない*場合" 887"です。" 888 889#. Tag: programlisting 890#: reference_operator.xml:543 891#, no-c-format 892msgid "" 893"SELECT tbl1.column1, tbl2.column1, tbl1.column2 &< tbl2.column2 AS " 894"overleft\n" 895"FROM\n" 896" ( VALUES\n" 897" (1, 'LINESTRING(1 2, 4 6)'::geometry)) AS tbl1,\n" 898" ( VALUES\n" 899" (2, 'LINESTRING(0 0, 3 3)'::geometry),\n" 900" (3, 'LINESTRING(0 1, 0 5)'::geometry),\n" 901" (4, 'LINESTRING(6 0, 6 1)'::geometry)) AS tbl2;\n" 902"\n" 903" column1 | column1 | overleft\n" 904"---------+---------+----------\n" 905" 1 | 2 | f\n" 906" 1 | 3 | f\n" 907" 1 | 4 | t\n" 908"(3 rows)" 909msgstr "" 910"SELECT tbl1.column1, tbl2.column1, tbl1.column2 &< tbl2.column2 AS " 911"overleft\n" 912"FROM\n" 913" ( VALUES\n" 914" (1, 'LINESTRING(1 2, 4 6)'::geometry)) AS tbl1,\n" 915" ( VALUES\n" 916" (2, 'LINESTRING(0 0, 3 3)'::geometry),\n" 917" (3, 'LINESTRING(0 1, 0 5)'::geometry),\n" 918" (4, 'LINESTRING(6 0, 6 1)'::geometry)) AS tbl2;\n" 919"\n" 920" column1 | column1 | overleft\n" 921"---------+---------+----------\n" 922" 1 | 2 | f\n" 923" 1 | 3 | f\n" 924" 1 | 4 | t\n" 925"(3 rows)" 926 927#. Tag: para 928#: reference_operator.xml:549 929#, no-c-format 930msgid "" 931", <xref linkend=\"ST_Geometry_Overabove\"/>, <xref linkend=" 932"\"ST_Geometry_Overright\"/>, <xref linkend=\"ST_Geometry_Overbelow\"/>" 933msgstr "" 934", <xref linkend=\"ST_Geometry_Overabove\"/>, <xref linkend=" 935"\"ST_Geometry_Overright\"/>, <xref linkend=\"ST_Geometry_Overbelow\"/>" 936 937#. Tag: refname 938#: reference_operator.xml:559 939#, no-c-format 940msgid "&<|" 941msgstr "&<|" 942 943#. Tag: refpurpose 944#: reference_operator.xml:561 945#, no-c-format 946msgid "" 947"Returns <varname>TRUE</varname> if A's bounding box overlaps or is below B's." 948msgstr "" 949"AのバウンディングボックスがBのバウンディングボックスをオーバラップするか、Bの" 950"バウンディングボックスの下にある場合に<varname>TRUE</varname>を返します。" 951 952#. Tag: funcprototype 953#: reference_operator.xml:566 954#, no-c-format 955msgid "" 956"<funcdef>boolean <function>&<|</function></funcdef> <paramdef> " 957"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 958"<type>geometry </type> <parameter>B</parameter> </paramdef>" 959msgstr "" 960"<funcdef>boolean <function>&<|</function></funcdef> <paramdef> " 961"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 962"<type>geometry </type> <parameter>B</parameter> </paramdef>" 963 964#. Tag: para 965#: reference_operator.xml:590 966#, no-c-format 967msgid "" 968"The <varname>&<|</varname> operator returns <varname>TRUE</varname> " 969"if the bounding box of geometry A overlaps or is below of the bounding box " 970"of geometry B, or more accurately, overlaps or is NOT above the bounding box " 971"of geometry B." 972msgstr "" 973"<varname>&<|</varname>演算子は、AのバウンディングボックスがBのバウン" 974"ディングボックスをオーバラップするか、Bのバウンディングボックスの下にある場合" 975"に<varname>TRUE</varname>を返します。条件についてより詳細に言うと、Bのバウン" 976"ディングボックスをオーバラップするかBのバウンディングボックスの上に*ない*場合" 977"です。" 978 979#. Tag: programlisting 980#: reference_operator.xml:604 981#, no-c-format 982msgid "" 983"SELECT tbl1.column1, tbl2.column1, tbl1.column2 &<| tbl2.column2 AS " 984"overbelow\n" 985"FROM\n" 986" ( VALUES\n" 987" (1, 'LINESTRING(6 0, 6 4)'::geometry)) AS tbl1,\n" 988" ( VALUES\n" 989" (2, 'LINESTRING(0 0, 3 3)'::geometry),\n" 990" (3, 'LINESTRING(0 1, 0 5)'::geometry),\n" 991" (4, 'LINESTRING(1 2, 4 6)'::geometry)) AS tbl2;\n" 992"\n" 993" column1 | column1 | overbelow\n" 994"---------+---------+-----------\n" 995" 1 | 2 | f\n" 996" 1 | 3 | t\n" 997" 1 | 4 | t\n" 998"(3 rows)" 999msgstr "" 1000"SELECT tbl1.column1, tbl2.column1, tbl1.column2 &<| tbl2.column2 AS " 1001"overbelow\n" 1002"FROM\n" 1003" ( VALUES\n" 1004" (1, 'LINESTRING(6 0, 6 4)'::geometry)) AS tbl1,\n" 1005" ( VALUES\n" 1006" (2, 'LINESTRING(0 0, 3 3)'::geometry),\n" 1007" (3, 'LINESTRING(0 1, 0 5)'::geometry),\n" 1008" (4, 'LINESTRING(1 2, 4 6)'::geometry)) AS tbl2;\n" 1009"\n" 1010" column1 | column1 | overbelow\n" 1011"---------+---------+-----------\n" 1012" 1 | 2 | f\n" 1013" 1 | 3 | t\n" 1014" 1 | 4 | t\n" 1015"(3 rows)" 1016 1017#. Tag: para 1018#: reference_operator.xml:610 1019#, no-c-format 1020msgid "" 1021", <xref linkend=\"ST_Geometry_Overabove\"/>, <xref linkend=" 1022"\"ST_Geometry_Overright\"/>, <xref linkend=\"ST_Geometry_Overleft\"/>" 1023msgstr "" 1024", <xref linkend=\"ST_Geometry_Overabove\"/>, <xref linkend=" 1025"\"ST_Geometry_Overright\"/>, <xref linkend=\"ST_Geometry_Overleft\"/>" 1026 1027#. Tag: refname 1028#: reference_operator.xml:620 1029#, no-c-format 1030msgid "&>" 1031msgstr "&>" 1032 1033#. Tag: refpurpose 1034#: reference_operator.xml:622 1035#, no-c-format 1036msgid "" 1037"Returns <varname>TRUE</varname> if A' bounding box overlaps or is to the " 1038"right of B's." 1039msgstr "" 1040"AのバウンディングボックスがBのバウンディングボックスをオーバラップするか、Bの" 1041"バウンディングボックスの右にある場合に<varname>TRUE</varname>を返します。" 1042 1043#. Tag: funcprototype 1044#: reference_operator.xml:627 1045#, no-c-format 1046msgid "" 1047"<funcdef>boolean <function>&></function></funcdef> <paramdef> " 1048"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 1049"<type>geometry </type> <parameter>B</parameter> </paramdef>" 1050msgstr "" 1051"<funcdef>boolean <function>&></function></funcdef> <paramdef> " 1052"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 1053"<type>geometry </type> <parameter>B</parameter> </paramdef>" 1054 1055#. Tag: para 1056#: reference_operator.xml:651 1057#, no-c-format 1058msgid "" 1059"The <varname>&></varname> operator returns <varname>TRUE</varname> if " 1060"the bounding box of geometry A overlaps or is to the right of the bounding " 1061"box of geometry B, or more accurately, overlaps or is NOT to the left of the " 1062"bounding box of geometry B." 1063msgstr "" 1064"<varname>&></varname>演算子は、AのバウンディングボックスがBのバウン" 1065"ディングボックスをオーバラップするか、Bのバウンディングボックスの右にある場合" 1066"に<varname>TRUE</varname>を返します。条件についてより詳細に言うと、Bのバウン" 1067"ディングボックスをオーバラップするかBのバウンディングボックスの左に*ない*場合" 1068"です。" 1069 1070#. Tag: programlisting 1071#: reference_operator.xml:662 1072#, no-c-format 1073msgid "" 1074"SELECT tbl1.column1, tbl2.column1, tbl1.column2 &> tbl2.column2 AS " 1075"overright\n" 1076"FROM\n" 1077" ( VALUES\n" 1078" (1, 'LINESTRING(1 2, 4 6)'::geometry)) AS tbl1,\n" 1079" ( VALUES\n" 1080" (2, 'LINESTRING(0 0, 3 3)'::geometry),\n" 1081" (3, 'LINESTRING(0 1, 0 5)'::geometry),\n" 1082" (4, 'LINESTRING(6 0, 6 1)'::geometry)) AS tbl2;\n" 1083"\n" 1084" column1 | column1 | overright\n" 1085"---------+---------+-----------\n" 1086" 1 | 2 | t\n" 1087" 1 | 3 | t\n" 1088" 1 | 4 | f\n" 1089"(3 rows)" 1090msgstr "" 1091"SELECT tbl1.column1, tbl2.column1, tbl1.column2 &> tbl2.column2 AS " 1092"overright\n" 1093"FROM\n" 1094" ( VALUES\n" 1095" (1, 'LINESTRING(1 2, 4 6)'::geometry)) AS tbl1,\n" 1096" ( VALUES\n" 1097" (2, 'LINESTRING(0 0, 3 3)'::geometry),\n" 1098" (3, 'LINESTRING(0 1, 0 5)'::geometry),\n" 1099" (4, 'LINESTRING(6 0, 6 1)'::geometry)) AS tbl2;\n" 1100"\n" 1101" column1 | column1 | overright\n" 1102"---------+---------+-----------\n" 1103" 1 | 2 | t\n" 1104" 1 | 3 | t\n" 1105" 1 | 4 | f\n" 1106"(3 rows)" 1107 1108#. Tag: para 1109#: reference_operator.xml:668 1110#, no-c-format 1111msgid "" 1112", <xref linkend=\"ST_Geometry_Overabove\"/>, <xref linkend=" 1113"\"ST_Geometry_Overbelow\"/>, <xref linkend=\"ST_Geometry_Overleft\"/>" 1114msgstr "" 1115", <xref linkend=\"ST_Geometry_Overabove\"/>, <xref linkend=" 1116"\"ST_Geometry_Overbelow\"/>, <xref linkend=\"ST_Geometry_Overleft\"/>" 1117 1118#. Tag: refname 1119#: reference_operator.xml:678 1120#, no-c-format 1121msgid "<<" 1122msgstr "<<" 1123 1124#. Tag: refpurpose 1125#: reference_operator.xml:680 1126#, no-c-format 1127msgid "" 1128"Returns <varname>TRUE</varname> if A's bounding box is strictly to the left " 1129"of B's." 1130msgstr "" 1131"Aのバウンダリボックスが、厳密にBのバウンダリボックスの左にある場合に" 1132"<varname>TRUE</varname>を返します。" 1133 1134#. Tag: funcprototype 1135#: reference_operator.xml:685 1136#, no-c-format 1137msgid "" 1138"<funcdef>boolean <function><<</function></funcdef> <paramdef> " 1139"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 1140"<type>geometry </type> <parameter>B</parameter> </paramdef>" 1141msgstr "" 1142"<funcdef>boolean <function><<</function></funcdef> <paramdef> " 1143"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 1144"<type>geometry </type> <parameter>B</parameter> </paramdef>" 1145 1146#. Tag: para 1147#: reference_operator.xml:709 1148#, no-c-format 1149msgid "" 1150"The <varname><<</varname> operator returns <varname>TRUE</varname> if " 1151"the bounding box of geometry A is strictly to the left of the bounding box " 1152"of geometry B." 1153msgstr "" 1154"<varname><<</varname>演算子はAのバウンダリボックスが、厳密にBのバウンダ" 1155"リボックスの左にある場合に<varname>TRUE</varname>を返します。" 1156 1157#. Tag: programlisting 1158#: reference_operator.xml:719 1159#, no-c-format 1160msgid "" 1161"SELECT tbl1.column1, tbl2.column1, tbl1.column2 << tbl2.column2 AS " 1162"left\n" 1163"FROM\n" 1164" ( VALUES\n" 1165" (1, 'LINESTRING (1 2, 1 5)'::geometry)) AS tbl1,\n" 1166" ( VALUES\n" 1167" (2, 'LINESTRING (0 0, 4 3)'::geometry),\n" 1168" (3, 'LINESTRING (6 0, 6 5)'::geometry),\n" 1169" (4, 'LINESTRING (2 2, 5 6)'::geometry)) AS tbl2;\n" 1170"\n" 1171" column1 | column1 | left\n" 1172"---------+---------+------\n" 1173" 1 | 2 | f\n" 1174" 1 | 3 | t\n" 1175" 1 | 4 | t\n" 1176"(3 rows)" 1177msgstr "" 1178"SELECT tbl1.column1, tbl2.column1, tbl1.column2 << tbl2.column2 AS " 1179"left\n" 1180"FROM\n" 1181" ( VALUES\n" 1182" (1, 'LINESTRING (1 2, 1 5)'::geometry)) AS tbl1,\n" 1183" ( VALUES\n" 1184" (2, 'LINESTRING (0 0, 4 3)'::geometry),\n" 1185" (3, 'LINESTRING (6 0, 6 5)'::geometry),\n" 1186" (4, 'LINESTRING (2 2, 5 6)'::geometry)) AS tbl2;\n" 1187"\n" 1188" column1 | column1 | left\n" 1189"---------+---------+------\n" 1190" 1 | 2 | f\n" 1191" 1 | 3 | t\n" 1192" 1 | 4 | t\n" 1193"(3 rows)" 1194 1195#. Tag: para 1196#: reference_operator.xml:725 reference_operator.xml:920 1197#, no-c-format 1198msgid "" 1199", <xref linkend=\"ST_Geometry_Above\"/>, <xref linkend=\"ST_Geometry_Below\"/" 1200">" 1201msgstr "" 1202", <xref linkend=\"ST_Geometry_Above\"/>, <xref linkend=\"ST_Geometry_Below\"/" 1203">" 1204 1205#. Tag: refname 1206#: reference_operator.xml:731 1207#, no-c-format 1208msgid "<<|" 1209msgstr "<<|" 1210 1211#. Tag: refpurpose 1212#: reference_operator.xml:733 1213#, no-c-format 1214msgid "" 1215"Returns <varname>TRUE</varname> if A's bounding box is strictly below B's." 1216msgstr "" 1217"Aのバウンダリボックスが、厳密にBのバウンダリボックスの下にある場合に" 1218"<varname>TRUE</varname>を返します。" 1219 1220#. Tag: funcprototype 1221#: reference_operator.xml:738 1222#, no-c-format 1223msgid "" 1224"<funcdef>boolean <function><<|</function></funcdef> <paramdef> " 1225"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 1226"<type>geometry </type> <parameter>B</parameter> </paramdef>" 1227msgstr "" 1228"<funcdef>boolean <function><<|</function></funcdef> <paramdef> " 1229"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 1230"<type>geometry </type> <parameter>B</parameter> </paramdef>" 1231 1232#. Tag: para 1233#: reference_operator.xml:762 1234#, no-c-format 1235msgid "" 1236"The <varname><<|</varname> operator returns <varname>TRUE</varname> if " 1237"the bounding box of geometry A is strictly below the bounding box of " 1238"geometry B." 1239msgstr "" 1240"<varname><<|</varname>演算子は、Aのバウンダリボックスが、厳密にBのバウ" 1241"ンダリボックスの下にある場合に<varname>TRUE</varname>を返します。" 1242 1243#. Tag: programlisting 1244#: reference_operator.xml:772 1245#, no-c-format 1246msgid "" 1247"SELECT tbl1.column1, tbl2.column1, tbl1.column2 <<| tbl2.column2 AS " 1248"below\n" 1249"FROM\n" 1250" ( VALUES\n" 1251" (1, 'LINESTRING (0 0, 4 3)'::geometry)) AS tbl1,\n" 1252" ( VALUES\n" 1253" (2, 'LINESTRING (1 4, 1 7)'::geometry),\n" 1254" (3, 'LINESTRING (6 1, 6 5)'::geometry),\n" 1255" (4, 'LINESTRING (2 3, 5 6)'::geometry)) AS tbl2;\n" 1256"\n" 1257" column1 | column1 | below\n" 1258"---------+---------+-------\n" 1259" 1 | 2 | t\n" 1260" 1 | 3 | f\n" 1261" 1 | 4 | f\n" 1262"(3 rows)" 1263msgstr "" 1264"SELECT tbl1.column1, tbl2.column1, tbl1.column2 <<| tbl2.column2 AS " 1265"below\n" 1266"FROM\n" 1267" ( VALUES\n" 1268" (1, 'LINESTRING (0 0, 4 3)'::geometry)) AS tbl1,\n" 1269" ( VALUES\n" 1270" (2, 'LINESTRING (1 4, 1 7)'::geometry),\n" 1271" (3, 'LINESTRING (6 1, 6 5)'::geometry),\n" 1272" (4, 'LINESTRING (2 3, 5 6)'::geometry)) AS tbl2;\n" 1273"\n" 1274" column1 | column1 | below\n" 1275"---------+---------+-------\n" 1276" 1 | 2 | t\n" 1277" 1 | 3 | f\n" 1278" 1 | 4 | f\n" 1279"(3 rows)" 1280 1281#. Tag: para 1282#: reference_operator.xml:778 1283#, no-c-format 1284msgid "" 1285", <xref linkend=\"ST_Geometry_Right\"/>, <xref linkend=\"ST_Geometry_Above\"/" 1286">" 1287msgstr "" 1288", <xref linkend=\"ST_Geometry_Right\"/>, <xref linkend=\"ST_Geometry_Above\"/" 1289">" 1290 1291#. Tag: refname 1292#: reference_operator.xml:784 1293#, no-c-format 1294msgid "=" 1295msgstr "=" 1296 1297#. Tag: refpurpose 1298#: reference_operator.xml:786 1299#, fuzzy, no-c-format 1300msgid "" 1301"Returns <varname>TRUE</varname> if the coordinates and coordinate order " 1302"geometry/geography A are the same as the coordinates and coordinate order of " 1303"geometry/geography B." 1304msgstr "" 1305"<varname>~=</varname>演算子はジオメトリ/ジオグラフィAのバウンディングボックス" 1306"がジオメトリ/ジオグラフィBのバウンディングボックスと同じ場合に<varname>TRUE</" 1307"varname>を返します。" 1308 1309#. Tag: funcsynopsis 1310#: reference_operator.xml:791 1311#, no-c-format 1312msgid "" 1313"<funcprototype> <funcdef>boolean <function>=</function></funcdef> " 1314"<paramdef> <type>geometry </type> <parameter>A</parameter> </paramdef> " 1315"<paramdef> <type>geometry </type> <parameter>B</parameter> </paramdef> </" 1316"funcprototype> <funcprototype> <funcdef>boolean <function>=</function></" 1317"funcdef> <paramdef> <type>geography </type> <parameter>A</parameter> </" 1318"paramdef> <paramdef> <type>geography </type> <parameter>B</parameter> </" 1319"paramdef> </funcprototype>" 1320msgstr "" 1321"<funcprototype> <funcdef>boolean <function>=</function></funcdef> " 1322"<paramdef> <type>geometry </type> <parameter>A</parameter> </paramdef> " 1323"<paramdef> <type>geometry </type> <parameter>B</parameter> </paramdef> </" 1324"funcprototype> <funcprototype> <funcdef>boolean <function>=</function></" 1325"funcdef> <paramdef> <type>geography </type> <parameter>A</parameter> </" 1326"paramdef> <paramdef> <type>geography </type> <parameter>B</parameter> </" 1327"paramdef> </funcprototype>" 1328 1329#. Tag: para 1330#: reference_operator.xml:832 1331#, fuzzy, no-c-format 1332msgid "" 1333"The <varname>=</varname> operator returns <varname>TRUE</varname> if the " 1334"coordinates and coordinate order geometry/geography A are the same as the " 1335"coordinates and coordinate order of geometry/geography B. PostgreSQL uses " 1336"the =, <, and > operators defined for geometries to perform internal " 1337"orderings and comparison of geometries (ie. in a GROUP BY or ORDER BY " 1338"clause)." 1339msgstr "" 1340"<varname>=</varname>演算子は、ジオメトリ/ジオグラフィAのバウンダリボックス" 1341"が、Bのバウンダリボックスと同じ場合に<varname>TRUE</varname>を返します。" 1342"PostgreSQLは、ジオメトリが内部の並べ替えの実行やジオメトリの比較を行うために" 1343"定義した=, <, >演算子を使います (GROUP BYやORDER BY節)。" 1344 1345#. Tag: para 1346#: reference_operator.xml:837 1347#, no-c-format 1348msgid "" 1349"Only geometry/geography that are exactly equal in all respects, with the " 1350"same coordinates, in the same order, are considered equal by this operator. " 1351"For \"spatial equality\", that ignores things like coordinate order, and can " 1352"detect features that cover the same spatial area with different " 1353"representations, use <xref linkend=\"ST_OrderingEquals\"/> or <xref linkend=" 1354"\"ST_Equals\"/>" 1355msgstr "" 1356 1357#. Tag: para 1358#: reference_operator.xml:846 1359#, fuzzy, no-c-format 1360msgid "" 1361"This operand will NOT make use of any indexes that may be available on the " 1362"geometries. For an index assisted exact equality test, combine = with " 1363"&&." 1364msgstr "これのオペランドはジオメトリで使用できるインデクスを*使いません*。" 1365 1366#. Tag: para 1367#: reference_operator.xml:850 1368#, no-c-format 1369msgid "" 1370"Changed: 2.4.0, in prior versions this was bounding box equality not a " 1371"geometric equality. If you need bounding box equality, use <xref linkend=" 1372"\"ST_Geometry_Same\"/> instead." 1373msgstr "" 1374 1375#. Tag: programlisting 1376#: reference_operator.xml:860 1377#, fuzzy, no-c-format 1378msgid "" 1379"SELECT 'LINESTRING(0 0, 0 1, 1 0)'::geometry = 'LINESTRING(1 1, 0 0)'::" 1380"geometry;\n" 1381" ?column?\n" 1382"----------\n" 1383" f\n" 1384"(1 row)\n" 1385"\n" 1386"SELECT ST_AsText(column1)\n" 1387"FROM ( VALUES\n" 1388" ('LINESTRING(0 0, 1 1)'::geometry),\n" 1389" ('LINESTRING(1 1, 0 0)'::geometry)) AS foo;\n" 1390" st_astext\n" 1391"---------------------\n" 1392" LINESTRING(0 0,1 1)\n" 1393" LINESTRING(1 1,0 0)\n" 1394"(2 rows)\n" 1395"\n" 1396"-- Note: the GROUP BY uses the \"=\" to compare for geometry equivalency.\n" 1397"SELECT ST_AsText(column1)\n" 1398"FROM ( VALUES\n" 1399" ('LINESTRING(0 0, 1 1)'::geometry),\n" 1400" ('LINESTRING(1 1, 0 0)'::geometry)) AS foo\n" 1401"GROUP BY column1;\n" 1402" st_astext\n" 1403"---------------------\n" 1404" LINESTRING(0 0,1 1)\n" 1405" LINESTRING(1 1,0 0)\n" 1406"(2 rows)\n" 1407"\n" 1408"-- In versions prior to 2.0, this used to return true --\n" 1409" SELECT ST_GeomFromText('POINT(1707296.37 4820536.77)') =\n" 1410" ST_GeomFromText('POINT(1707296.27 4820536.87)') As pt_intersect;\n" 1411"\n" 1412"--pt_intersect --\n" 1413"f" 1414msgstr "" 1415"SELECT 'LINESTRING(0 0, 0 1, 1 0)'::geometry = 'LINESTRING(1 1, 0 0)'::" 1416"geometry;\n" 1417" ?column?\n" 1418"----------\n" 1419" t\n" 1420"(1 row)\n" 1421"\n" 1422"SELECT ST_AsText(column1)\n" 1423"FROM ( VALUES\n" 1424" ('LINESTRING(0 0, 1 1)'::geometry),\n" 1425" ('LINESTRING(1 1, 0 0)'::geometry)) AS foo;\n" 1426" st_astext\n" 1427"---------------------\n" 1428" LINESTRING(0 0,1 1)\n" 1429" LINESTRING(1 1,0 0)\n" 1430"(2 rows)\n" 1431"\n" 1432"-- Note: the GROUP BY uses the \"=\" to compare for geometry equivalency.\n" 1433"SELECT ST_AsText(column1)\n" 1434"FROM ( VALUES\n" 1435" ('LINESTRING(0 0, 1 1)'::geometry),\n" 1436" ('LINESTRING(1 1, 0 0)'::geometry)) AS foo\n" 1437"GROUP BY column1;\n" 1438" st_astext\n" 1439"---------------------\n" 1440" LINESTRING(0 0,1 1)\n" 1441"(1 row)\n" 1442"\n" 1443"-- 2.0より前の版では、これはTRUEを返します --\n" 1444" SELECT ST_GeomFromText('POINT(1707296.37 4820536.77)') =\n" 1445" ST_GeomFromText('POINT(1707296.27 4820536.87)') As pt_intersect;\n" 1446"\n" 1447"--pt_intersect --\n" 1448"f" 1449 1450#. Tag: para 1451#: reference_operator.xml:866 1452#, fuzzy, no-c-format 1453msgid "" 1454", <xref linkend=\"ST_OrderingEquals\"/>, <xref linkend=\"ST_Geometry_Same\"/>" 1455msgstr "" 1456", <xref linkend=\"ST_OrderingEquals\"/>, <xref linkend=\"ST_Geometry_EQ\"/>" 1457 1458#. Tag: refname 1459#: reference_operator.xml:873 1460#, no-c-format 1461msgid ">>" 1462msgstr ">>" 1463 1464#. Tag: refpurpose 1465#: reference_operator.xml:875 1466#, no-c-format 1467msgid "" 1468"Returns <varname>TRUE</varname> if A's bounding box is strictly to the right " 1469"of B's." 1470msgstr "" 1471"Aのバウンダリボックスが、厳密にBのバウンダリボックスの右にある場合に" 1472"<varname>TRUE</varname>を返します。" 1473 1474#. Tag: funcprototype 1475#: reference_operator.xml:880 1476#, no-c-format 1477msgid "" 1478"<funcdef>boolean <function>>></function></funcdef> <paramdef> " 1479"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 1480"<type>geometry </type> <parameter>B</parameter> </paramdef>" 1481msgstr "" 1482"<funcdef>boolean <function>>></function></funcdef> <paramdef> " 1483"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 1484"<type>geometry </type> <parameter>B</parameter> </paramdef>" 1485 1486#. Tag: para 1487#: reference_operator.xml:904 1488#, no-c-format 1489msgid "" 1490"The <varname>>></varname> operator returns <varname>TRUE</varname> if " 1491"the bounding box of geometry A is strictly to the right of the bounding box " 1492"of geometry B." 1493msgstr "" 1494"<varname>>></varname>演算子は、Aのバウンダリボックスが、厳密にBのバウン" 1495"ダリボックスの右にある場合に<varname>TRUE</varname>を返します。" 1496 1497#. Tag: programlisting 1498#: reference_operator.xml:914 1499#, no-c-format 1500msgid "" 1501"SELECT tbl1.column1, tbl2.column1, tbl1.column2 >> tbl2.column2 AS " 1502"right\n" 1503"FROM\n" 1504" ( VALUES\n" 1505" (1, 'LINESTRING (2 3, 5 6)'::geometry)) AS tbl1,\n" 1506" ( VALUES\n" 1507" (2, 'LINESTRING (1 4, 1 7)'::geometry),\n" 1508" (3, 'LINESTRING (6 1, 6 5)'::geometry),\n" 1509" (4, 'LINESTRING (0 0, 4 3)'::geometry)) AS tbl2;\n" 1510"\n" 1511" column1 | column1 | right\n" 1512"---------+---------+-------\n" 1513" 1 | 2 | t\n" 1514" 1 | 3 | f\n" 1515" 1 | 4 | f\n" 1516"(3 rows)" 1517msgstr "" 1518"SELECT tbl1.column1, tbl2.column1, tbl1.column2 >> tbl2.column2 AS " 1519"right\n" 1520"FROM\n" 1521" ( VALUES\n" 1522" (1, 'LINESTRING (2 3, 5 6)'::geometry)) AS tbl1,\n" 1523" ( VALUES\n" 1524" (2, 'LINESTRING (1 4, 1 7)'::geometry),\n" 1525" (3, 'LINESTRING (6 1, 6 5)'::geometry),\n" 1526" (4, 'LINESTRING (0 0, 4 3)'::geometry)) AS tbl2;\n" 1527"\n" 1528" column1 | column1 | right\n" 1529"---------+---------+-------\n" 1530" 1 | 2 | t\n" 1531" 1 | 3 | f\n" 1532" 1 | 4 | f\n" 1533"(3 rows)" 1534 1535#. Tag: refname 1536#: reference_operator.xml:926 1537#, no-c-format 1538msgid "<refname>@</refname>" 1539msgstr "<refname>@</refname>" 1540 1541#. Tag: refpurpose 1542#: reference_operator.xml:928 1543#, no-c-format 1544msgid "" 1545"Returns <varname>TRUE</varname> if A's bounding box is contained by B's." 1546msgstr "" 1547"AのバウンダリボックスがBのバウンダリボックスに含まれている場合に" 1548"<varname>TRUE</varname>を返します。" 1549 1550#. Tag: funcprototype 1551#: reference_operator.xml:933 1552#, no-c-format 1553msgid "" 1554"<funcdef>boolean <function>@</function></funcdef> <paramdef> <type>geometry " 1555"</type> <parameter>A</parameter> </paramdef> <paramdef> <type>geometry </" 1556"type> <parameter>B</parameter> </paramdef>" 1557msgstr "" 1558"<funcdef>boolean <function>@</function></funcdef> <paramdef> <type>geometry " 1559"</type> <parameter>A</parameter> </paramdef> <paramdef> <type>geometry </" 1560"type> <parameter>B</parameter> </paramdef>" 1561 1562#. Tag: para 1563#: reference_operator.xml:957 1564#, no-c-format 1565msgid "" 1566"The <varname>@</varname> operator returns <varname>TRUE</varname> if the " 1567"bounding box of geometry A is completely contained by the bounding box of " 1568"geometry B." 1569msgstr "" 1570"<varname>@</varname>演算子は、AのバウンダリボックスがBのバウンダリボックス" 1571"に、完全に含まれている場合に<varname>TRUE</varname>を返します。" 1572 1573#. Tag: programlisting 1574#: reference_operator.xml:969 1575#, no-c-format 1576msgid "" 1577"SELECT tbl1.column1, tbl2.column1, tbl1.column2 @ tbl2.column2 AS contained\n" 1578"FROM\n" 1579" ( VALUES\n" 1580" (1, 'LINESTRING (1 1, 3 3)'::geometry)) AS tbl1,\n" 1581" ( VALUES\n" 1582" (2, 'LINESTRING (0 0, 4 4)'::geometry),\n" 1583" (3, 'LINESTRING (2 2, 4 4)'::geometry),\n" 1584" (4, 'LINESTRING (1 1, 3 3)'::geometry)) AS tbl2;\n" 1585"\n" 1586" column1 | column1 | contained\n" 1587"---------+---------+-----------\n" 1588" 1 | 2 | t\n" 1589" 1 | 3 | f\n" 1590" 1 | 4 | t\n" 1591"(3 rows)" 1592msgstr "" 1593"SELECT tbl1.column1, tbl2.column1, tbl1.column2 @ tbl2.column2 AS contained\n" 1594"FROM\n" 1595" ( VALUES\n" 1596" (1, 'LINESTRING (1 1, 3 3)'::geometry)) AS tbl1,\n" 1597" ( VALUES\n" 1598" (2, 'LINESTRING (0 0, 4 4)'::geometry),\n" 1599" (3, 'LINESTRING (2 2, 4 4)'::geometry),\n" 1600" (4, 'LINESTRING (1 1, 3 3)'::geometry)) AS tbl2;\n" 1601"\n" 1602" column1 | column1 | contained\n" 1603"---------+---------+-----------\n" 1604" 1 | 2 | t\n" 1605" 1 | 3 | f\n" 1606" 1 | 4 | t\n" 1607"(3 rows)" 1608 1609#. Tag: para 1610#: reference_operator.xml:975 reference_operator.xml:1322 1611#, no-c-format 1612msgid ", <xref linkend=\"geometry_overlaps\"/>" 1613msgstr ", <xref linkend=\"geometry_overlaps\"/>" 1614 1615#. Tag: refname 1616#: reference_operator.xml:981 1617#, no-c-format 1618msgid "@(geometry,box2df)" 1619msgstr "@(geometry,box2df)" 1620 1621#. Tag: refpurpose 1622#: reference_operator.xml:983 1623#, no-c-format 1624msgid "" 1625"Returns <varname>TRUE</varname> if a geometry's 2D bounding box is contained " 1626"into a 2D float precision bounding box (BOX2DF)." 1627msgstr "" 1628"ジオメトリの2次元バウンディングボックスが単精度浮動小数点数による2次元バウン" 1629"ディングボックス (BOX2DF)に包含される場合に<varname>TRUE</varname>を返しま" 1630"す。" 1631 1632#. Tag: funcprototype 1633#: reference_operator.xml:988 1634#, no-c-format 1635msgid "" 1636"<funcdef>boolean <function>@</function></funcdef> <paramdef> <type>geometry " 1637"</type> <parameter>A</parameter> </paramdef> <paramdef> <type>box2df </type> " 1638"<parameter>B</parameter> </paramdef>" 1639msgstr "" 1640"<funcdef>boolean <function>@</function></funcdef> <paramdef> <type>geometry " 1641"</type> <parameter>A</parameter> </paramdef> <paramdef> <type>box2df </type> " 1642"<parameter>B</parameter> </paramdef>" 1643 1644#. Tag: para 1645#: reference_operator.xml:1009 1646#, no-c-format 1647msgid "" 1648"The <varname>@</varname> operator returns <varname>TRUE</varname> if the A " 1649"geometry's 2D bounding box is contained the 2D bounding box B, using float " 1650"precision. This means that if B is a (double precision) box2d, it will be " 1651"internally converted to a float precision 2D bounding box (BOX2DF)" 1652msgstr "" 1653"<varname>@</varname>演算子は、ジオメトリAの2次元バウンディングボックスが、2次" 1654"元バウンディングボックスBに包含される場合に、<varname>TRUE</varname>を返しま" 1655"す。単精度浮動小数点数によるバウンディングボックスを使います。Bが倍精度浮動小" 1656"数点数を使うbox2dである場合には、単精度浮動小数点数によるバウンディングボック" 1657"ス (BOX2DF)に変換されることになります。" 1658 1659#. Tag: programlisting 1660#: reference_operator.xml:1022 1661#, no-c-format 1662msgid "" 1663"SELECT ST_Buffer(ST_GeomFromText('POINT(2 2)'), 1) @ " 1664"ST_MakeBox2D(ST_MakePoint(0,0), ST_MakePoint(5,5)) AS is_contained;\n" 1665"\n" 1666" is_contained\n" 1667"--------------\n" 1668" t\n" 1669"(1 row)" 1670msgstr "" 1671"SELECT ST_Buffer(ST_GeomFromText('POINT(2 2)'), 1) @ " 1672"ST_MakeBox2D(ST_MakePoint(0,0), ST_MakePoint(5,5)) AS is_contained;\n" 1673"\n" 1674" is_contained\n" 1675"--------------\n" 1676" t\n" 1677"(1 row)" 1678 1679#. Tag: para 1680#: reference_operator.xml:1028 1681#, no-c-format 1682msgid "" 1683", <xref linkend=\"overlaps_box2df_geometry\"/>, <xref linkend=" 1684"\"overlaps_box2df_box2df\"/>, <xref linkend=\"contains_geometry_box2df\"/>, " 1685"<xref linkend=\"contains_box2df_geometry\"/>, <xref linkend=" 1686"\"contains_box2df_box2df\"/>, <xref linkend=\"is_contained_box2df_geometry\"/" 1687">, <xref linkend=\"is_contained_box2df_box2df\"/>" 1688msgstr "" 1689", <xref linkend=\"overlaps_box2df_geometry\"/>, <xref linkend=" 1690"\"overlaps_box2df_box2df\"/>, <xref linkend=\"contains_geometry_box2df\"/>, " 1691"<xref linkend=\"contains_box2df_geometry\"/>, <xref linkend=" 1692"\"contains_box2df_box2df\"/>, <xref linkend=\"is_contained_box2df_geometry\"/" 1693">, <xref linkend=\"is_contained_box2df_box2df\"/>" 1694 1695#. Tag: refname 1696#: reference_operator.xml:1042 1697#, no-c-format 1698msgid "@(box2df,geometry)" 1699msgstr "@(box2df,geometry)" 1700 1701#. Tag: refpurpose 1702#: reference_operator.xml:1044 1703#, no-c-format 1704msgid "" 1705"Returns <varname>TRUE</varname> if a 2D float precision bounding box " 1706"(BOX2DF) is contained into a geometry's 2D bounding box." 1707msgstr "" 1708"単精度浮動小数点数による2次元バウンディングボックス (BOX2DF)がジオメトリの2次" 1709"元バウンディングボックスに包含される場合に<varname>TRUE</varname>を返します。" 1710 1711#. Tag: funcprototype 1712#: reference_operator.xml:1049 1713#, no-c-format 1714msgid "" 1715"<funcdef>boolean <function>@</function></funcdef> <paramdef> <type>box2df </" 1716"type> <parameter>A</parameter> </paramdef> <paramdef> <type>geometry </type> " 1717"<parameter>B</parameter> </paramdef>" 1718msgstr "" 1719"<funcdef>boolean <function>@</function></funcdef> <paramdef> <type>box2df </" 1720"type> <parameter>A</parameter> </paramdef> <paramdef> <type>geometry </type> " 1721"<parameter>B</parameter> </paramdef>" 1722 1723#. Tag: para 1724#: reference_operator.xml:1070 1725#, no-c-format 1726msgid "" 1727"The <varname>@</varname> operator returns <varname>TRUE</varname> if the 2D " 1728"bounding box A is contained into the B geometry's 2D bounding box, using " 1729"float precision. This means that if B is a (double precision) box2d, it will " 1730"be internally converted to a float precision 2D bounding box (BOX2DF)" 1731msgstr "" 1732"<varname>@</varname>演算子は、2次元バウンディングボックスAが、ジオメトリBの2" 1733"次元バウンディングボックスに包含される場合に、<varname>TRUE</varname>を返しま" 1734"す。単精度浮動小数点数によるバウンディングボックスを使います。Aが倍精度浮動小" 1735"数点数を使うbox2dである場合には、単精度浮動小数点数によるバウンディングボック" 1736"ス (BOX2DF)に変換されることになります。" 1737 1738#. Tag: programlisting 1739#: reference_operator.xml:1083 1740#, no-c-format 1741msgid "" 1742"SELECT ST_MakeBox2D(ST_MakePoint(2,2), ST_MakePoint(3,3)) @ " 1743"ST_Buffer(ST_GeomFromText('POINT(1 1)'), 10) AS is_contained;\n" 1744"\n" 1745" is_contained\n" 1746"--------------\n" 1747" t\n" 1748"(1 row)" 1749msgstr "" 1750"SELECT ST_MakeBox2D(ST_MakePoint(2,2), ST_MakePoint(3,3)) @ " 1751"ST_Buffer(ST_GeomFromText('POINT(1 1)'), 10) AS is_contained;\n" 1752"\n" 1753" is_contained\n" 1754"--------------\n" 1755" t\n" 1756"(1 row)" 1757 1758#. Tag: para 1759#: reference_operator.xml:1089 1760#, no-c-format 1761msgid "" 1762", <xref linkend=\"overlaps_box2df_geometry\"/>, <xref linkend=" 1763"\"overlaps_box2df_box2df\"/>, <xref linkend=\"contains_geometry_box2df\"/>, " 1764"<xref linkend=\"contains_box2df_geometry\"/>, <xref linkend=" 1765"\"contains_box2df_box2df\"/>, <xref linkend=\"is_contained_geometry_box2df\"/" 1766">, <xref linkend=\"is_contained_box2df_box2df\"/>" 1767msgstr "" 1768", <xref linkend=\"overlaps_box2df_geometry\"/>, <xref linkend=" 1769"\"overlaps_box2df_box2df\"/>, <xref linkend=\"contains_geometry_box2df\"/>, " 1770"<xref linkend=\"contains_box2df_geometry\"/>, <xref linkend=" 1771"\"contains_box2df_box2df\"/>, <xref linkend=\"is_contained_geometry_box2df\"/" 1772">, <xref linkend=\"is_contained_box2df_box2df\"/>" 1773 1774#. Tag: refname 1775#: reference_operator.xml:1103 1776#, no-c-format 1777msgid "@(box2df,box2df)" 1778msgstr "@(box2df,box2df)" 1779 1780#. Tag: refpurpose 1781#: reference_operator.xml:1105 1782#, no-c-format 1783msgid "" 1784"Returns <varname>TRUE</varname> if a 2D float precision bounding box " 1785"(BOX2DF) is contained into another 2D float precision bounding box." 1786msgstr "" 1787"二つの単精度浮動小数点数によるn次元バウンディングボックス (GIDX)の一方がもう" 1788"一方を包含する場合に<varname>TRUE</varname>を返します。" 1789 1790#. Tag: funcprototype 1791#: reference_operator.xml:1110 1792#, no-c-format 1793msgid "" 1794"<funcdef>boolean <function>@</function></funcdef> <paramdef> <type>box2df </" 1795"type> <parameter>A</parameter> </paramdef> <paramdef> <type>box2df </type> " 1796"<parameter>B</parameter> </paramdef>" 1797msgstr "" 1798"<funcdef>boolean <function>@</function></funcdef> <paramdef> <type>box2df </" 1799"type> <parameter>A</parameter> </paramdef> <paramdef> <type>box2df </type> " 1800"<parameter>B</parameter> </paramdef>" 1801 1802#. Tag: para 1803#: reference_operator.xml:1131 1804#, no-c-format 1805msgid "" 1806"The <varname>@</varname> operator returns <varname>TRUE</varname> if the 2D " 1807"bounding box A is contained into the 2D bounding box B, using float " 1808"precision. This means that if A (or B) is a (double precision) box2d, it " 1809"will be internally converted to a float precision 2D bounding box (BOX2DF)" 1810msgstr "" 1811"<varname>@</varname>演算子は、2次元バウンディングボックスAが2次元バウンディン" 1812"グボックスBに包含される場合には、<varname>TRUE</varname>を返します。単精度浮" 1813"動小数点数によるバウンディングボックスを使います。AまたはBが倍精度浮動小数点" 1814"数を使うbox2dである場合には、単精度浮動小数点数によるバウンディングボックス " 1815"(BOX2DF)に変換されることになります。" 1816 1817#. Tag: programlisting 1818#: reference_operator.xml:1144 1819#, no-c-format 1820msgid "" 1821"SELECT ST_MakeBox2D(ST_MakePoint(2,2), ST_MakePoint(3,3)) @ " 1822"ST_MakeBox2D(ST_MakePoint(0,0), ST_MakePoint(5,5)) AS is_contained;\n" 1823"\n" 1824" is_contained\n" 1825"--------------\n" 1826" t\n" 1827"(1 row)" 1828msgstr "" 1829"SELECT ST_MakeBox2D(ST_MakePoint(2,2), ST_MakePoint(3,3)) @ " 1830"ST_MakeBox2D(ST_MakePoint(0,0), ST_MakePoint(5,5)) AS is_contained;\n" 1831"\n" 1832" is_contained\n" 1833"--------------\n" 1834" t\n" 1835"(1 row)" 1836 1837#. Tag: para 1838#: reference_operator.xml:1150 1839#, no-c-format 1840msgid "" 1841", <xref linkend=\"overlaps_box2df_geometry\"/>, <xref linkend=" 1842"\"overlaps_box2df_box2df\"/>, <xref linkend=\"contains_geometry_box2df\"/>, " 1843"<xref linkend=\"contains_box2df_geometry\"/>, <xref linkend=" 1844"\"contains_box2df_box2df\"/>, <xref linkend=\"is_contained_geometry_box2df\"/" 1845">, <xref linkend=\"is_contained_box2df_geometry\"/>" 1846msgstr "" 1847", <xref linkend=\"overlaps_box2df_geometry\"/>, <xref linkend=" 1848"\"overlaps_box2df_box2df\"/>, <xref linkend=\"contains_geometry_box2df\"/>, " 1849"<xref linkend=\"contains_box2df_geometry\"/>, <xref linkend=" 1850"\"contains_box2df_box2df\"/>, <xref linkend=\"is_contained_geometry_box2df\"/" 1851">, <xref linkend=\"is_contained_box2df_geometry\"/>" 1852 1853#. Tag: refname 1854#: reference_operator.xml:1164 1855#, no-c-format 1856msgid "|&>" 1857msgstr "|&>" 1858 1859#. Tag: refpurpose 1860#: reference_operator.xml:1166 1861#, no-c-format 1862msgid "" 1863"Returns <varname>TRUE</varname> if A's bounding box overlaps or is above B's." 1864msgstr "" 1865"AのバウンディングボックスがBのバウンディングボックスをオーバラップするか、Bの" 1866"バウンディングボックスの上にある場合に<varname>TRUE</varname>を返します。" 1867 1868#. Tag: funcprototype 1869#: reference_operator.xml:1171 1870#, no-c-format 1871msgid "" 1872"<funcdef>boolean <function>|&></function></funcdef> <paramdef> " 1873"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 1874"<type>geometry </type> <parameter>B</parameter> </paramdef>" 1875msgstr "" 1876"<funcdef>boolean <function>|&></function></funcdef> <paramdef> " 1877"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 1878"<type>geometry </type> <parameter>B</parameter> </paramdef>" 1879 1880#. Tag: para 1881#: reference_operator.xml:1195 1882#, no-c-format 1883msgid "" 1884"The <varname>|&></varname> operator returns <varname>TRUE</varname> " 1885"if the bounding box of geometry A overlaps or is above the bounding box of " 1886"geometry B, or more accurately, overlaps or is NOT below the bounding box of " 1887"geometry B." 1888msgstr "" 1889"<varname>|&></varname>演算子は、AのバウンディングボックスがBのバウン" 1890"ディングボックスをオーバラップするか、Bのバウンディングボックスの上にある場合" 1891"に<varname>TRUE</varname>を返します。条件についてより詳細に言うと、Bのバウン" 1892"ディングボックスをオーバラップするかBのバウンディングボックスの下に*ない*場合" 1893"です。" 1894 1895#. Tag: programlisting 1896#: reference_operator.xml:1206 1897#, no-c-format 1898msgid "" 1899"SELECT tbl1.column1, tbl2.column1, tbl1.column2 |&> tbl2.column2 AS " 1900"overabove\n" 1901"FROM\n" 1902" ( VALUES\n" 1903" (1, 'LINESTRING(6 0, 6 4)'::geometry)) AS tbl1,\n" 1904" ( VALUES\n" 1905" (2, 'LINESTRING(0 0, 3 3)'::geometry),\n" 1906" (3, 'LINESTRING(0 1, 0 5)'::geometry),\n" 1907" (4, 'LINESTRING(1 2, 4 6)'::geometry)) AS tbl2;\n" 1908"\n" 1909" column1 | column1 | overabove\n" 1910"---------+---------+-----------\n" 1911" 1 | 2 | t\n" 1912" 1 | 3 | f\n" 1913" 1 | 4 | f\n" 1914"(3 rows)" 1915msgstr "" 1916"SELECT tbl1.column1, tbl2.column1, tbl1.column2 |&> tbl2.column2 AS " 1917"overabove\n" 1918"FROM\n" 1919" ( VALUES\n" 1920" (1, 'LINESTRING(6 0, 6 4)'::geometry)) AS tbl1,\n" 1921" ( VALUES\n" 1922" (2, 'LINESTRING(0 0, 3 3)'::geometry),\n" 1923" (3, 'LINESTRING(0 1, 0 5)'::geometry),\n" 1924" (4, 'LINESTRING(1 2, 4 6)'::geometry)) AS tbl2;\n" 1925"\n" 1926" column1 | column1 | overabove\n" 1927"---------+---------+-----------\n" 1928" 1 | 2 | t\n" 1929" 1 | 3 | f\n" 1930" 1 | 4 | f\n" 1931"(3 rows)" 1932 1933#. Tag: para 1934#: reference_operator.xml:1212 1935#, no-c-format 1936msgid "" 1937", <xref linkend=\"ST_Geometry_Overright\"/>, <xref linkend=" 1938"\"ST_Geometry_Overbelow\"/>, <xref linkend=\"ST_Geometry_Overleft\"/>" 1939msgstr "" 1940", <xref linkend=\"ST_Geometry_Overright\"/>, <xref linkend=" 1941"\"ST_Geometry_Overbelow\"/>, <xref linkend=\"ST_Geometry_Overleft\"/>" 1942 1943#. Tag: refname 1944#: reference_operator.xml:1222 1945#, no-c-format 1946msgid "|>>" 1947msgstr "|>>" 1948 1949#. Tag: refpurpose 1950#: reference_operator.xml:1224 1951#, no-c-format 1952msgid "" 1953"Returns <varname>TRUE</varname> if A's bounding box is strictly above B's." 1954msgstr "" 1955"Aのバウンダリボックスが、厳密にBのバウンダリボックスの上にある場合に" 1956"<varname>TRUE</varname>を返します。" 1957 1958#. Tag: funcprototype 1959#: reference_operator.xml:1229 1960#, no-c-format 1961msgid "" 1962"<funcdef>boolean <function>|>></function></funcdef> <paramdef> " 1963"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 1964"<type>geometry </type> <parameter>B</parameter> </paramdef>" 1965msgstr "" 1966"<funcdef>boolean <function>|>></function></funcdef> <paramdef> " 1967"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 1968"<type>geometry </type> <parameter>B</parameter> </paramdef>" 1969 1970#. Tag: para 1971#: reference_operator.xml:1253 1972#, fuzzy, no-c-format 1973msgid "" 1974"The <varname>|>></varname> operator returns <varname>TRUE</varname> if " 1975"the bounding box of geometry A is strictly above the bounding box of " 1976"geometry B." 1977msgstr "" 1978"<varname><<|</varname>演算子は、Aのバウンダリボックスが、厳密にBのバウ" 1979"ンダリボックスの下にある場合に<varname>TRUE</varname>を返します。" 1980 1981#. Tag: programlisting 1982#: reference_operator.xml:1263 1983#, no-c-format 1984msgid "" 1985"SELECT tbl1.column1, tbl2.column1, tbl1.column2 |>> tbl2.column2 AS " 1986"above\n" 1987"FROM\n" 1988" ( VALUES\n" 1989" (1, 'LINESTRING (1 4, 1 7)'::geometry)) AS tbl1,\n" 1990" ( VALUES\n" 1991" (2, 'LINESTRING (0 0, 4 2)'::geometry),\n" 1992" (3, 'LINESTRING (6 1, 6 5)'::geometry),\n" 1993" (4, 'LINESTRING (2 3, 5 6)'::geometry)) AS tbl2;\n" 1994"\n" 1995" column1 | column1 | above\n" 1996"---------+---------+-------\n" 1997" 1 | 2 | t\n" 1998" 1 | 3 | f\n" 1999" 1 | 4 | f\n" 2000"(3 rows)" 2001msgstr "" 2002"SELECT tbl1.column1, tbl2.column1, tbl1.column2 |>> tbl2.column2 AS " 2003"above\n" 2004"FROM\n" 2005" ( VALUES\n" 2006" (1, 'LINESTRING (1 4, 1 7)'::geometry)) AS tbl1,\n" 2007" ( VALUES\n" 2008" (2, 'LINESTRING (0 0, 4 2)'::geometry),\n" 2009" (3, 'LINESTRING (6 1, 6 5)'::geometry),\n" 2010" (4, 'LINESTRING (2 3, 5 6)'::geometry)) AS tbl2;\n" 2011"\n" 2012" column1 | column1 | above\n" 2013"---------+---------+-------\n" 2014" 1 | 2 | t\n" 2015" 1 | 3 | f\n" 2016" 1 | 4 | f\n" 2017"(3 rows)" 2018 2019#. Tag: para 2020#: reference_operator.xml:1269 2021#, no-c-format 2022msgid "" 2023", <xref linkend=\"ST_Geometry_Right\"/>, <xref linkend=\"ST_Geometry_Below\"/" 2024">" 2025msgstr "" 2026", <xref linkend=\"ST_Geometry_Right\"/>, <xref linkend=\"ST_Geometry_Below\"/" 2027">" 2028 2029#. Tag: refname 2030#: reference_operator.xml:1275 2031#, no-c-format 2032msgid "<refname>~</refname>" 2033msgstr "<refname>~</refname>" 2034 2035#. Tag: refpurpose 2036#: reference_operator.xml:1277 2037#, no-c-format 2038msgid "Returns <varname>TRUE</varname> if A's bounding box contains B's." 2039msgstr "" 2040"AのバウンディングボックスがBのバウンディングボックスを含む場合に" 2041"<varname>TRUE</varname>を返します。" 2042 2043#. Tag: funcprototype 2044#: reference_operator.xml:1282 2045#, no-c-format 2046msgid "" 2047"<funcdef>boolean <function>~</function></funcdef> <paramdef> <type>geometry " 2048"</type> <parameter>A</parameter> </paramdef> <paramdef> <type>geometry </" 2049"type> <parameter>B</parameter> </paramdef>" 2050msgstr "" 2051"<funcdef>boolean <function>~</function></funcdef> <paramdef> <type>geometry " 2052"</type> <parameter>A</parameter> </paramdef> <paramdef> <type>geometry </" 2053"type> <parameter>B</parameter> </paramdef>" 2054 2055#. Tag: para 2056#: reference_operator.xml:1306 2057#, no-c-format 2058msgid "" 2059"The <varname>~</varname> operator returns <varname>TRUE</varname> if the " 2060"bounding box of geometry A completely contains the bounding box of geometry " 2061"B." 2062msgstr "" 2063"<varname>~</varname>演算子は、AのバウンディングボックスがBのバウンディング" 2064"ボックスを、完全に含む場合に<varname>TRUE</varname>を返します。" 2065 2066#. Tag: programlisting 2067#: reference_operator.xml:1316 2068#, no-c-format 2069msgid "" 2070"SELECT tbl1.column1, tbl2.column1, tbl1.column2 ~ tbl2.column2 AS contains\n" 2071"FROM\n" 2072" ( VALUES\n" 2073" (1, 'LINESTRING (0 0, 3 3)'::geometry)) AS tbl1,\n" 2074" ( VALUES\n" 2075" (2, 'LINESTRING (0 0, 4 4)'::geometry),\n" 2076" (3, 'LINESTRING (1 1, 2 2)'::geometry),\n" 2077" (4, 'LINESTRING (0 0, 3 3)'::geometry)) AS tbl2;\n" 2078"\n" 2079" column1 | column1 | contains\n" 2080"---------+---------+----------\n" 2081" 1 | 2 | f\n" 2082" 1 | 3 | t\n" 2083" 1 | 4 | t\n" 2084"(3 rows)" 2085msgstr "" 2086"SELECT tbl1.column1, tbl2.column1, tbl1.column2 ~ tbl2.column2 AS contains\n" 2087"FROM\n" 2088" ( VALUES\n" 2089" (1, 'LINESTRING (0 0, 3 3)'::geometry)) AS tbl1,\n" 2090" ( VALUES\n" 2091" (2, 'LINESTRING (0 0, 4 4)'::geometry),\n" 2092" (3, 'LINESTRING (1 1, 2 2)'::geometry),\n" 2093" (4, 'LINESTRING (0 0, 3 3)'::geometry)) AS tbl2;\n" 2094"\n" 2095" column1 | column1 | contains\n" 2096"---------+---------+----------\n" 2097" 1 | 2 | f\n" 2098" 1 | 3 | t\n" 2099" 1 | 4 | t\n" 2100"(3 rows)" 2101 2102#. Tag: refname 2103#: reference_operator.xml:1328 2104#, no-c-format 2105msgid "~(geometry,box2df)" 2106msgstr "~(geometry,box2df)" 2107 2108#. Tag: refpurpose 2109#: reference_operator.xml:1330 2110#, no-c-format 2111msgid "" 2112"Returns <varname>TRUE</varname> if a geometry's 2D bonding box contains a 2D " 2113"float precision bounding box (GIDX)." 2114msgstr "" 2115"ジオメトリの (キャッシュされている)2次元バウンディングボックスが単精度浮動小" 2116"数点数によるn次元バウンディングボックス (GIDX)を包含する場合に<varname>TRUE</" 2117"varname>を返します。" 2118 2119#. Tag: funcprototype 2120#: reference_operator.xml:1335 2121#, no-c-format 2122msgid "" 2123"<funcdef>boolean <function>~</function></funcdef> <paramdef> <type>geometry " 2124"</type> <parameter>A</parameter> </paramdef> <paramdef> <type>box2df </type> " 2125"<parameter>B</parameter> </paramdef>" 2126msgstr "" 2127"<funcdef>boolean <function>~</function></funcdef> <paramdef> <type>geometry " 2128"</type> <parameter>A</parameter> </paramdef> <paramdef> <type>box2df </type> " 2129"<parameter>B</parameter> </paramdef>" 2130 2131#. Tag: para 2132#: reference_operator.xml:1356 2133#, no-c-format 2134msgid "" 2135"The <varname>~</varname> operator returns <varname>TRUE</varname> if the 2D " 2136"bounding box of a geometry A contains the 2D bounding box B, using float " 2137"precision. This means that if B is a (double precision) box2d, it will be " 2138"internally converted to a float precision 2D bounding box (BOX2DF)" 2139msgstr "" 2140"<varname>~</varname>演算子は、ジオメトリAの2次元バウンディングボックスが、2次" 2141"元バウンディングボックスBを包含する場合に、<varname>TRUE</varname>を返しま" 2142"す。単精度浮動小数点数によるバウンディングボックスを使います。Bが倍精度浮動小" 2143"数点数を使うbox2dである場合には、単精度浮動小数点数によるバウンディングボック" 2144"ス (BOX2DF)に変換されることになります。" 2145 2146#. Tag: programlisting 2147#: reference_operator.xml:1369 2148#, no-c-format 2149msgid "" 2150"SELECT ST_Buffer(ST_GeomFromText('POINT(1 1)'), 10) ~ " 2151"ST_MakeBox2D(ST_MakePoint(0,0), ST_MakePoint(2,2)) AS contains;\n" 2152"\n" 2153" contains\n" 2154"----------\n" 2155" t\n" 2156"(1 row)" 2157msgstr "" 2158"SELECT ST_Buffer(ST_GeomFromText('POINT(1 1)'), 10) ~ " 2159"ST_MakeBox2D(ST_MakePoint(0,0), ST_MakePoint(2,2)) AS contains;\n" 2160"\n" 2161" contains\n" 2162"----------\n" 2163" t\n" 2164"(1 row)" 2165 2166#. Tag: para 2167#: reference_operator.xml:1375 2168#, no-c-format 2169msgid "" 2170", <xref linkend=\"overlaps_box2df_geometry\"/>, <xref linkend=" 2171"\"overlaps_box2df_box2df\"/>, <xref linkend=\"contains_box2df_geometry\"/>, " 2172"<xref linkend=\"contains_box2df_box2df\"/>, <xref linkend=" 2173"\"is_contained_geometry_box2df\"/>, <xref linkend=" 2174"\"is_contained_box2df_geometry\"/>, <xref linkend=" 2175"\"is_contained_box2df_box2df\"/>" 2176msgstr "" 2177", <xref linkend=\"overlaps_box2df_geometry\"/>, <xref linkend=" 2178"\"overlaps_box2df_box2df\"/>, <xref linkend=\"contains_box2df_geometry\"/>, " 2179"<xref linkend=\"contains_box2df_box2df\"/>, <xref linkend=" 2180"\"is_contained_geometry_box2df\"/>, <xref linkend=" 2181"\"is_contained_box2df_geometry\"/>, <xref linkend=" 2182"\"is_contained_box2df_box2df\"/>" 2183 2184#. Tag: refname 2185#: reference_operator.xml:1389 2186#, no-c-format 2187msgid "~(box2df,geometry)" 2188msgstr "~(box2df,geometry)" 2189 2190#. Tag: refpurpose 2191#: reference_operator.xml:1391 2192#, no-c-format 2193msgid "" 2194"Returns <varname>TRUE</varname> if a 2D float precision bounding box " 2195"(BOX2DF) contains a geometry's 2D bonding box." 2196msgstr "" 2197"単精度浮動小数点数による2次元バウンディングボックス (BOX2DF)をジオメトリの " 2198"(キャッシュされている)2次元バウンディングボックスが包含する場合に" 2199"<varname>TRUE</varname>を返します。" 2200 2201#. Tag: funcprototype 2202#: reference_operator.xml:1396 2203#, no-c-format 2204msgid "" 2205"<funcdef>boolean <function>~</function></funcdef> <paramdef> <type>box2df </" 2206"type> <parameter>A</parameter> </paramdef> <paramdef> <type>geometry </type> " 2207"<parameter>B</parameter> </paramdef>" 2208msgstr "" 2209"<funcdef>boolean <function>~</function></funcdef> <paramdef> <type>box2df </" 2210"type> <parameter>A</parameter> </paramdef> <paramdef> <type>geometry </type> " 2211"<parameter>B</parameter> </paramdef>" 2212 2213#. Tag: para 2214#: reference_operator.xml:1417 2215#, no-c-format 2216msgid "" 2217"The <varname>~</varname> operator returns <varname>TRUE</varname> if the 2D " 2218"bounding box A contains the B geometry's bounding box, using float " 2219"precision. This means that if A is a (double precision) box2d, it will be " 2220"internally converted to a float precision 2D bounding box (BOX2DF)" 2221msgstr "" 2222"<varname>~</varname>演算子は、2次元バウンディングボックスAが、ジオメトリBの2" 2223"次元バウンディングボックスを包含する場合に、<varname>TRUE</varname>を返しま" 2224"す。単精度浮動小数点数によるバウンディングボックスを使います。Aが倍精度浮動小" 2225"数点数を使うbox2dである場合には、単精度浮動小数点数によるバウンディングボック" 2226"ス (BOX2DF)に変換されることになります。" 2227 2228#. Tag: programlisting 2229#: reference_operator.xml:1430 2230#, no-c-format 2231msgid "" 2232"SELECT ST_MakeBox2D(ST_MakePoint(0,0), ST_MakePoint(5,5)) ~ " 2233"ST_Buffer(ST_GeomFromText('POINT(2 2)'), 1) AS contains;\n" 2234"\n" 2235" contains\n" 2236"----------\n" 2237" t\n" 2238"(1 row)" 2239msgstr "" 2240"SELECT ST_MakeBox2D(ST_MakePoint(0,0), ST_MakePoint(5,5)) ~ " 2241"ST_Buffer(ST_GeomFromText('POINT(2 2)'), 1) AS contains;\n" 2242"\n" 2243" contains\n" 2244"----------\n" 2245" t\n" 2246"(1 row)" 2247 2248#. Tag: para 2249#: reference_operator.xml:1436 2250#, no-c-format 2251msgid "" 2252", <xref linkend=\"overlaps_box2df_geometry\"/>, <xref linkend=" 2253"\"overlaps_box2df_box2df\"/>, <xref linkend=\"contains_geometry_box2df\"/>, " 2254"<xref linkend=\"contains_box2df_box2df\"/>, <xref linkend=" 2255"\"is_contained_geometry_box2df\"/>, <xref linkend=" 2256"\"is_contained_box2df_geometry\"/>, <xref linkend=" 2257"\"is_contained_box2df_box2df\"/>" 2258msgstr "" 2259", <xref linkend=\"overlaps_box2df_geometry\"/>, <xref linkend=" 2260"\"overlaps_box2df_box2df\"/>, <xref linkend=\"contains_geometry_box2df\"/>, " 2261"<xref linkend=\"contains_box2df_box2df\"/>, <xref linkend=" 2262"\"is_contained_geometry_box2df\"/>, <xref linkend=" 2263"\"is_contained_box2df_geometry\"/>, <xref linkend=" 2264"\"is_contained_box2df_box2df\"/>" 2265 2266#. Tag: refname 2267#: reference_operator.xml:1450 2268#, no-c-format 2269msgid "~(box2df,box2df)" 2270msgstr "~(box2df,box2df)" 2271 2272#. Tag: refpurpose 2273#: reference_operator.xml:1452 2274#, no-c-format 2275msgid "" 2276"Returns <varname>TRUE</varname> if a 2D float precision bounding box " 2277"(BOX2DF) contains another 2D float precision bounding box (BOX2DF)." 2278msgstr "" 2279"二つの単精度浮動小数点数による2次元バウンディングボックス (BOX2DF)の一方がも" 2280"う一方を包含する場合に<varname>TRUE</varname>を返します。" 2281 2282#. Tag: funcprototype 2283#: reference_operator.xml:1457 2284#, no-c-format 2285msgid "" 2286"<funcdef>boolean <function>~</function></funcdef> <paramdef> <type>box2df </" 2287"type> <parameter>A</parameter> </paramdef> <paramdef> <type>box2df </type> " 2288"<parameter>B</parameter> </paramdef>" 2289msgstr "" 2290"<funcdef>boolean <function>~</function></funcdef> <paramdef> <type>box2df </" 2291"type> <parameter>A</parameter> </paramdef> <paramdef> <type>box2df </type> " 2292"<parameter>B</parameter> </paramdef>" 2293 2294#. Tag: para 2295#: reference_operator.xml:1478 2296#, no-c-format 2297msgid "" 2298"The <varname>~</varname> operator returns <varname>TRUE</varname> if the 2D " 2299"bounding box A contains the 2D bounding box B, using float precision. This " 2300"means that if A is a (double precision) box2d, it will be internally " 2301"converted to a float precision 2D bounding box (BOX2DF)" 2302msgstr "" 2303"<varname>~</varname>演算子は、2次元バウンディングボックスAが、2次元バウンディ" 2304"ングボックスBを包含する場合に、<varname>TRUE</varname>を返します。単精度浮動" 2305"小数点数によるバウンディングボックスを使います。AまたはBが倍精度浮動小数点数" 2306"を使うbox2dである場合には、単精度浮動小数点数によるバウンディングボックス " 2307"(BOX2DF)に変換されることになります。" 2308 2309#. Tag: programlisting 2310#: reference_operator.xml:1491 2311#, no-c-format 2312msgid "" 2313"SELECT ST_MakeBox2D(ST_MakePoint(0,0), ST_MakePoint(5,5)) ~ " 2314"ST_MakeBox2D(ST_MakePoint(2,2), ST_MakePoint(3,3)) AS contains;\n" 2315"\n" 2316" contains\n" 2317"----------\n" 2318" t\n" 2319"(1 row)" 2320msgstr "" 2321"SELECT ST_MakeBox2D(ST_MakePoint(0,0), ST_MakePoint(5,5)) ~ " 2322"ST_MakeBox2D(ST_MakePoint(2,2), ST_MakePoint(3,3)) AS contains;\n" 2323"\n" 2324" contains\n" 2325"----------\n" 2326" t\n" 2327"(1 row)" 2328 2329#. Tag: para 2330#: reference_operator.xml:1497 2331#, no-c-format 2332msgid "" 2333", <xref linkend=\"overlaps_box2df_geometry\"/>, <xref linkend=" 2334"\"overlaps_box2df_box2df\"/>, <xref linkend=\"contains_geometry_box2df\"/>, " 2335"<xref linkend=\"contains_box2df_geometry\"/>, <xref linkend=" 2336"\"is_contained_geometry_box2df\"/>, <xref linkend=" 2337"\"is_contained_box2df_geometry\"/>, <xref linkend=" 2338"\"is_contained_box2df_box2df\"/>" 2339msgstr "" 2340", <xref linkend=\"overlaps_box2df_geometry\"/>, <xref linkend=" 2341"\"overlaps_box2df_box2df\"/>, <xref linkend=\"contains_geometry_box2df\"/>, " 2342"<xref linkend=\"contains_box2df_geometry\"/>, <xref linkend=" 2343"\"is_contained_geometry_box2df\"/>, <xref linkend=" 2344"\"is_contained_box2df_geometry\"/>, <xref linkend=" 2345"\"is_contained_box2df_box2df\"/>" 2346 2347#. Tag: refname 2348#: reference_operator.xml:1511 2349#, no-c-format 2350msgid "<refname>~=</refname>" 2351msgstr "<refname>~=</refname>" 2352 2353#. Tag: refpurpose 2354#: reference_operator.xml:1513 2355#, no-c-format 2356msgid "Returns <varname>TRUE</varname> if A's bounding box is the same as B's." 2357msgstr "" 2358"AのバウンディングボックスがBのバウンディングボックスと同じ場合にTRUEを返しま" 2359"す。" 2360 2361#. Tag: funcprototype 2362#: reference_operator.xml:1518 2363#, no-c-format 2364msgid "" 2365"<funcdef>boolean <function>~=</function></funcdef> <paramdef> <type>geometry " 2366"</type> <parameter>A</parameter> </paramdef> <paramdef> <type>geometry </" 2367"type> <parameter>B</parameter> </paramdef>" 2368msgstr "" 2369"<funcdef>boolean <function>~=</function></funcdef> <paramdef> <type>geometry " 2370"</type> <parameter>A</parameter> </paramdef> <paramdef> <type>geometry </" 2371"type> <parameter>B</parameter> </paramdef>" 2372 2373#. Tag: para 2374#: reference_operator.xml:1542 2375#, no-c-format 2376msgid "" 2377"The <varname>~=</varname> operator returns <varname>TRUE</varname> if the " 2378"bounding box of geometry/geography A is the same as the bounding box of " 2379"geometry/geography B." 2380msgstr "" 2381"<varname>~=</varname>演算子はジオメトリ/ジオグラフィAのバウンディングボックス" 2382"がジオメトリ/ジオグラフィBのバウンディングボックスと同じ場合に<varname>TRUE</" 2383"varname>を返します。" 2384 2385#. Tag: para 2386#: reference_operator.xml:1548 2387#, no-c-format 2388msgid "Availability: 1.5.0 changed behavior" 2389msgstr "Availability: 1.5.0 挙動が変更されました" 2390 2391#. Tag: para 2392#: reference_operator.xml:1552 2393#, fuzzy, no-c-format 2394msgid "" 2395"This operator has changed behavior in PostGIS 1.5 from testing for actual " 2396"geometric equality to only checking for bounding box equality. To complicate " 2397"things it also depends on if you have done a hard or soft upgrade which " 2398"behavior your database has. To find out which behavior your database has you " 2399"can run the query below. To check for true equality use <xref linkend=" 2400"\"ST_OrderingEquals\"/> or <xref linkend=\"ST_Equals\"/>." 2401msgstr "" 2402"この演算子の挙動はPostGIS 1.5で、実際のジオメトリとしての等価性のテストから、" 2403"バウンディングボックスの等価性のテストに変更されました。ハードアップグレード" 2404"またはソフトアップグレードを実行している場合は、データベースがどの挙動を持つ" 2405"かに動作が依存して、ややこしくなります。データベースがどの挙動を持つか判断す" 2406"るために、下のクエリを実行することができます。本当の等価性をチェックするには" 2407"<xref linkend=\"ST_OrderingEquals\"/>または <xref linkend=\"ST_Equals\"/>を使" 2408"用し、バウンディングボックスの等価性をチェックするには<xref linkend=" 2409"\"ST_Geometry_EQ\"/>を使用するのが、安全な選択肢です。" 2410 2411#. Tag: programlisting 2412#: reference_operator.xml:1565 2413#, no-c-format 2414msgid "" 2415"select 'LINESTRING(0 0, 1 1)'::geometry ~= 'LINESTRING(0 1, 1 0)'::geometry " 2416"as equality;\n" 2417" equality |\n" 2418"-----------------+\n" 2419" t |" 2420msgstr "" 2421"select 'LINESTRING(0 0, 1 1)'::geometry ~= 'LINESTRING(0 1, 1 0)'::geometry " 2422"as equality;\n" 2423" equality |\n" 2424"-----------------+\n" 2425" t |" 2426 2427#. Tag: para 2428#: reference_operator.xml:1569 2429#, no-c-format 2430msgid "" 2431", <xref linkend=\"ST_OrderingEquals\"/>, <xref linkend=\"ST_Geometry_EQ\"/>" 2432msgstr "" 2433", <xref linkend=\"ST_OrderingEquals\"/>, <xref linkend=\"ST_Geometry_EQ\"/>" 2434 2435#. Tag: refname 2436#: reference_operator.xml:1575 2437#, no-c-format 2438msgid "<->" 2439msgstr "<->" 2440 2441#. Tag: refpurpose 2442#: reference_operator.xml:1577 2443#, no-c-format 2444msgid "Returns the 2D distance between A and B." 2445msgstr "AとBの2次元距離を返します。" 2446 2447#. Tag: funcsynopsis 2448#: reference_operator.xml:1583 2449#, no-c-format 2450msgid "" 2451"<funcprototype> <funcdef>double precision <function><-></function></" 2452"funcdef> <paramdef> <type>geometry </type> <parameter>A</parameter> </" 2453"paramdef> <paramdef> <type>geometry </type> <parameter>B</parameter> </" 2454"paramdef> </funcprototype> <funcprototype> <funcdef>double precision " 2455"<function><-></function></funcdef> <paramdef> <type>geography </type> " 2456"<parameter>A</parameter> </paramdef> <paramdef> <type>geography </type> " 2457"<parameter>B</parameter> </paramdef> </funcprototype>" 2458msgstr "" 2459"<funcprototype> <funcdef>double precision <function><-></function></" 2460"funcdef> <paramdef> <type>geometry </type> <parameter>A</parameter> </" 2461"paramdef> <paramdef> <type>geometry </type> <parameter>B</parameter> </" 2462"paramdef> </funcprototype> <funcprototype> <funcdef>double precision " 2463"<function><-></function></funcdef> <paramdef> <type>geography </type> " 2464"<parameter>A</parameter> </paramdef> <paramdef> <type>geography </type> " 2465"<parameter>B</parameter> </paramdef> </funcprototype>" 2466 2467#. Tag: para 2468#: reference_operator.xml:1621 2469#, no-c-format 2470msgid "" 2471"The <varname><-></varname> operator returns the 2D distance between " 2472"two geometries. Used in the \"ORDER BY\" clause provides index-assisted " 2473"nearest-neighbor result sets. For PostgreSQL below 9.5 only gives centroid " 2474"distance of bounding boxes and for PostgreSQL 9.5+, does true KNN distance " 2475"search giving true distance between geometries, and distance sphere for " 2476"geographies." 2477msgstr "" 2478"<varname><-></varname>演算子は二つのジオメトリの2次元距離を返しま" 2479"す。\"ORDER BY\"句内で使われ、インデクスの援助を受けた近傍結果集合を提供しま" 2480"す。PostgreSQL 9.5より前では、バウンディングボックスの中心距離を出すだけでし" 2481"たが、PostgreSQL 9.5以上では、ジオメトリ間の本当の距離が与えられた本当のKNN距" 2482"離検索を行います。ジオグラフィでは球面上の距離を計算します。" 2483 2484#. Tag: para 2485#: reference_operator.xml:1630 2486#, no-c-format 2487msgid "" 2488"This operand will make use of 2D GiST indexes that may be available on the " 2489"geometries. It is different from other operators that use spatial indexes in " 2490"that the spatial index is only used when the operator is in the ORDER BY " 2491"clause." 2492msgstr "" 2493"これのオペランドはジオメトリで利用できるインデクスを使用します。他の演算子と" 2494"の相違点は、ORDER BY句でのみインデクスが使用される点です。" 2495 2496#. Tag: para 2497#: reference_operator.xml:1631 reference_operator.xml:1824 2498#, no-c-format 2499msgid "" 2500"Index only kicks in if one of the geometries is a constant (not in a " 2501"subquery/cte). e.g. 'SRID=3005;POINT(1011102 450541)'::geometry instead of a." 2502"geom" 2503msgstr "" 2504"ジオメトリのひとつが定数となる (副問い合わせ/共通テーブル式にない)場合 (a." 2505"geomでなく'SRID=3005;POINT(1011102 450541)'::geometry等となる場合)には、イン" 2506"デクスが有効になるだけです。" 2507 2508#. Tag: para 2509#: reference_operator.xml:1632 2510#, no-c-format 2511msgid "" 2512"Refer to <ulink url=\"http://workshops.opengeo.org/postgis-intro/knn.html" 2513"\">OpenGeo workshop: Nearest-Neighbour Searching</ulink> for real live " 2514"example." 2515msgstr "" 2516"実際の生きた例については<ulink url=\"http://workshops.opengeo.org/postgis-" 2517"intro/knn.html\">OpenGeo workshop: Nearest-Neighbour Searching</ulink>を参照" 2518"して下さい。" 2519 2520#. Tag: para 2521#: reference_operator.xml:1634 2522#, no-c-format 2523msgid "" 2524"Enhanced: 2.2.0 -- True KNN (\"K nearest neighbor\") behavior for geometry " 2525"and geography for PostgreSQL 9.5+. Note for geography KNN is based on sphere " 2526"rather than spheroid. For PostgreSQL 9.4 and below, geography support is new " 2527"but only supports centroid box." 2528msgstr "" 2529"Enhanced: 2.2.0 ジオメトリとジオグラフィとのKNN (k近傍法)の動作が本当のものに" 2530"なりました。ジオグラフィのKNNは回転楕円体面上でなく球面上の計算となることに注" 2531"意して下さい。PostgreSQL 9.4以下では、ジオグラフィに対応していますが、バウン" 2532"ディングボックスの重心に対応するだけです。" 2533 2534#. Tag: para 2535#: reference_operator.xml:1635 2536#, no-c-format 2537msgid "" 2538"Changed: 2.2.0 -- For PostgreSQL 9.5 users, old Hybrid syntax may be slower, " 2539"so you'll want to get rid of that hack if you are running your code only on " 2540"PostGIS 2.2+ 9.5+. See examples below." 2541msgstr "" 2542"Changed: 2.2.0 PostgreSQL 9.5では、古いハイブリッド書式は遅くなりる可能性があ" 2543"ります。そのため、PostGIS 2.2以上かつPostgreSQL 9.5以上においてのみ動作させる" 2544"場合には、そのやり方をり除きたくなるでしょう。" 2545 2546#. Tag: para 2547#: reference_operator.xml:1636 2548#, no-c-format 2549msgid "" 2550"Availability: 2.0.0 -- Weak KNN provides nearest neighbors based on geometry " 2551"centroid distances instead of true distances. Exact results for points, " 2552"inexact for all other types. Available for PostgreSQL 9.1+" 2553msgstr "" 2554"Availability: 2.0.0 弱いKNNによって、実際の距離の代わりにジオメトリの重心によ" 2555"る近傍が得られます。ポイントは確実な結果を得て、他のタイプは全て不確実な結果" 2556"を得ます。PostgreSQL 9.1以上で有効です。" 2557 2558#. Tag: programlisting 2559#: reference_operator.xml:1643 2560#, no-c-format 2561msgid "" 2562"<![CDATA[SELECT ST_Distance(geom, 'SRID=3005;POINT(1011102 450541)'::" 2563"geometry) as d,edabbr, vaabbr\n" 2564"FROM va2005\n" 2565"ORDER BY d limit 10;]]>\n" 2566"\n" 2567" d | edabbr | vaabbr\n" 2568"------------------+--------+--------\n" 2569" 0 | ALQ | 128\n" 2570" 5541.57712511724 | ALQ | 129A\n" 2571" 5579.67450712005 | ALQ | 001\n" 2572" 6083.4207708641 | ALQ | 131\n" 2573" 7691.2205404848 | ALQ | 003\n" 2574" 7900.75451037313 | ALQ | 122\n" 2575" 8694.20710669982 | ALQ | 129B\n" 2576" 9564.24289057111 | ALQ | 130\n" 2577" 12089.665931705 | ALQ | 127\n" 2578" 18472.5531479404 | ALQ | 002\n" 2579"(10 rows)" 2580msgstr "" 2581"<![CDATA[SELECT ST_Distance(geom, 'SRID=3005;POINT(1011102 450541)'::" 2582"geometry) as d,edabbr, vaabbr\n" 2583"FROM va2005\n" 2584"ORDER BY d limit 10;]]>\n" 2585"\n" 2586" d | edabbr | vaabbr\n" 2587"------------------+--------+--------\n" 2588" 0 | ALQ | 128\n" 2589" 5541.57712511724 | ALQ | 129A\n" 2590" 5579.67450712005 | ALQ | 001\n" 2591" 6083.4207708641 | ALQ | 131\n" 2592" 7691.2205404848 | ALQ | 003\n" 2593" 7900.75451037313 | ALQ | 122\n" 2594" 8694.20710669982 | ALQ | 129B\n" 2595" 9564.24289057111 | ALQ | 130\n" 2596" 12089.665931705 | ALQ | 127\n" 2597" 18472.5531479404 | ALQ | 002\n" 2598"(10 rows)" 2599 2600#. Tag: para 2601#: reference_operator.xml:1644 2602#, no-c-format 2603msgid "Then the KNN raw answer:" 2604msgstr "KNNの生の答は次のとおりです。" 2605 2606#. Tag: programlisting 2607#: reference_operator.xml:1647 2608#, no-c-format 2609msgid "" 2610"<![CDATA[SELECT st_distance(geom, 'SRID=3005;POINT(1011102 450541)'::" 2611"geometry) as d,edabbr, vaabbr\n" 2612"FROM va2005\n" 2613"ORDER BY geom <-> 'SRID=3005;POINT(1011102 450541)'::geometry limit 10;]]>\n" 2614"\n" 2615" d | edabbr | vaabbr\n" 2616"------------------+--------+--------\n" 2617" 0 | ALQ | 128\n" 2618" 5541.57712511724 | ALQ | 129A\n" 2619" 5579.67450712005 | ALQ | 001\n" 2620" 6083.4207708641 | ALQ | 131\n" 2621" 7691.2205404848 | ALQ | 003\n" 2622" 7900.75451037313 | ALQ | 122\n" 2623" 8694.20710669982 | ALQ | 129B\n" 2624" 9564.24289057111 | ALQ | 130\n" 2625" 12089.665931705 | ALQ | 127\n" 2626" 18472.5531479404 | ALQ | 002\n" 2627"(10 rows)" 2628msgstr "" 2629"<![CDATA[SELECT st_distance(geom, 'SRID=3005;POINT(1011102 450541)'::" 2630"geometry) as d,edabbr, vaabbr\n" 2631"FROM va2005\n" 2632"ORDER BY geom <-> 'SRID=3005;POINT(1011102 450541)'::geometry limit 10;]]>\n" 2633"\n" 2634" d | edabbr | vaabbr\n" 2635"------------------+--------+--------\n" 2636" 0 | ALQ | 128\n" 2637" 5541.57712511724 | ALQ | 129A\n" 2638" 5579.67450712005 | ALQ | 001\n" 2639" 6083.4207708641 | ALQ | 131\n" 2640" 7691.2205404848 | ALQ | 003\n" 2641" 7900.75451037313 | ALQ | 122\n" 2642" 8694.20710669982 | ALQ | 129B\n" 2643" 9564.24289057111 | ALQ | 130\n" 2644" 12089.665931705 | ALQ | 127\n" 2645" 18472.5531479404 | ALQ | 002\n" 2646"(10 rows)" 2647 2648#. Tag: para 2649#: reference_operator.xml:1648 2650#, no-c-format 2651msgid "" 2652"If you run \"EXPLAIN ANALYZE\" on the two queries you would see a " 2653"performance improvement for the second." 2654msgstr "" 2655"二つのクエリで\"EXPLAIN ANALYZE\"を実行すると、二つ目で速度が改善したことが分" 2656"かります。" 2657 2658#. Tag: para 2659#: reference_operator.xml:1652 2660#, no-c-format 2661msgid "" 2662"For users running with PostgreSQL < 9.5, use a hybrid query to find the " 2663"true nearest neighbors. First a CTE query using the index-assisted KNN, then " 2664"an exact query to get correct ordering:" 2665msgstr "" 2666"PostgreSQL 9.5未満では、実際の近傍を発見するために、ハイブリッドのクエリを使" 2667"います。最初にインデクスを用いたKNNを使って共通テーブル式 (CTE)クエリを行い、" 2668"正しい順序を得る確実なクエリを実行します。" 2669 2670#. Tag: programlisting 2671#: reference_operator.xml:1655 2672#, no-c-format 2673msgid "" 2674"<![CDATA[WITH index_query AS (\n" 2675" SELECT ST_Distance(geom, 'SRID=3005;POINT(1011102 450541)'::geometry) as d," 2676"edabbr, vaabbr\n" 2677" FROM va2005\n" 2678" ORDER BY geom <-> 'SRID=3005;POINT(1011102 450541)'::geometry LIMIT 100)\n" 2679" SELECT *\n" 2680" FROM index_query\n" 2681" ORDER BY d limit 10;]]>\n" 2682"\n" 2683" d | edabbr | vaabbr\n" 2684"------------------+--------+--------\n" 2685" 0 | ALQ | 128\n" 2686" 5541.57712511724 | ALQ | 129A\n" 2687" 5579.67450712005 | ALQ | 001\n" 2688" 6083.4207708641 | ALQ | 131\n" 2689" 7691.2205404848 | ALQ | 003\n" 2690" 7900.75451037313 | ALQ | 122\n" 2691" 8694.20710669982 | ALQ | 129B\n" 2692" 9564.24289057111 | ALQ | 130\n" 2693" 12089.665931705 | ALQ | 127\n" 2694" 18472.5531479404 | ALQ | 002\n" 2695"(10 rows)" 2696msgstr "" 2697"<![CDATA[WITH index_query AS (\n" 2698" SELECT ST_Distance(geom, 'SRID=3005;POINT(1011102 450541)'::geometry) as d," 2699"edabbr, vaabbr\n" 2700" FROM va2005\n" 2701" ORDER BY geom <-> 'SRID=3005;POINT(1011102 450541)'::geometry LIMIT 100)\n" 2702" SELECT *\n" 2703" FROM index_query\n" 2704" ORDER BY d limit 10;]]>\n" 2705"\n" 2706" d | edabbr | vaabbr\n" 2707"------------------+--------+--------\n" 2708" 0 | ALQ | 128\n" 2709" 5541.57712511724 | ALQ | 129A\n" 2710" 5579.67450712005 | ALQ | 001\n" 2711" 6083.4207708641 | ALQ | 131\n" 2712" 7691.2205404848 | ALQ | 003\n" 2713" 7900.75451037313 | ALQ | 122\n" 2714" 8694.20710669982 | ALQ | 129B\n" 2715" 9564.24289057111 | ALQ | 130\n" 2716" 12089.665931705 | ALQ | 127\n" 2717" 18472.5531479404 | ALQ | 002\n" 2718"(10 rows)" 2719 2720#. Tag: para 2721#: reference_operator.xml:1659 2722#, no-c-format 2723msgid "" 2724", <xref linkend=\"ST_Distance\"/>, <xref linkend=\"geometry_distance_box\"/>" 2725msgstr "" 2726", <xref linkend=\"ST_Distance\"/>, <xref linkend=\"geometry_distance_box\"/>" 2727 2728#. Tag: refname 2729#: reference_operator.xml:1665 2730#, no-c-format 2731msgid "<refname>|=|</refname>" 2732msgstr "<refname>|=|</refname>" 2733 2734#. Tag: refpurpose 2735#: reference_operator.xml:1667 2736#, no-c-format 2737msgid "" 2738"Returns the distance between A and B trajectories at their closest point of " 2739"approach." 2740msgstr "AトラジェクトリとBトラジェクトリとの最接近する時の距離を返します。" 2741 2742#. Tag: funcprototype 2743#: reference_operator.xml:1674 2744#, no-c-format 2745msgid "" 2746"<funcdef>double precision <function>|=|</function></funcdef> <paramdef> " 2747"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 2748"<type>geometry </type> <parameter>B</parameter> </paramdef>" 2749msgstr "" 2750"<funcdef>double precision <function>|=|</function></funcdef> <paramdef> " 2751"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 2752"<type>geometry </type> <parameter>B</parameter> </paramdef>" 2753 2754#. Tag: para 2755#: reference_operator.xml:1696 2756#, no-c-format 2757msgid "" 2758"The <varname>|=|</varname> operator returns the 3D distance between two " 2759"trajectories (See <xref linkend=\"ST_IsValidTrajectory\"/>). This is the " 2760"same as <xref linkend=\"ST_DistanceCPA\"/> but as an operator it can be used " 2761"for doing nearest neightbor searches using an N-dimensional index (requires " 2762"PostgreSQL 9.5.0 or higher)." 2763msgstr "" 2764"<varname>|=|</varname>演算子は二つのトラジェクトリの3次元距離を返します " 2765"(<xref linkend=\"ST_IsValidTrajectory\"/>を参照して下さい)。これは、<xref " 2766"linkend=\"ST_DistanceCPA\"/>と同じですが、N次元インデクスを使った近傍探索 " 2767"(PostgreSQL 9.5.0以上)で使われる演算子です。" 2768 2769#. Tag: para 2770#: reference_operator.xml:1704 2771#, no-c-format 2772msgid "" 2773"This operand will make use of ND GiST indexes that may be available on the " 2774"geometries. It is different from other operators that use spatial indexes in " 2775"that the spatial index is only used when the operator is in the ORDER BY " 2776"clause." 2777msgstr "" 2778"この演算子は、ジオメトリで使用可能なND GiST (n次元GiST)インデクスを使用しま" 2779"す。他の空間インデクスを使う演算子と違い、ORDER BY句でのみ空間インデクスを使" 2780"います。" 2781 2782#. Tag: para 2783#: reference_operator.xml:1705 2784#, no-c-format 2785msgid "" 2786"Index only kicks in if one of the geometries is a constant (not in a " 2787"subquery/cte). e.g. 'SRID=3005;LINESTRINGM(0 0 0,0 0 1)'::geometry instead " 2788"of a.geom" 2789msgstr "" 2790"ジオメトリのひとつが定数となる (副問い合わせ/共通テーブル式にない)場合 (a." 2791"geomでなく'SRID=3005;LINESTRINGM(0 0 0,0 0 1)'::geometry等となる場合)には、イ" 2792"ンデクスが有効になるだけです。" 2793 2794#. Tag: para 2795#: reference_operator.xml:1707 2796#, no-c-format 2797msgid "Availability: 2.2.0. Index-supported only available for PostgreSQL 9.5+" 2798msgstr "" 2799"Availability:: 2.2.0 インデクス対応はPostgreSQL 9.5以上でのみ有効です。" 2800 2801#. Tag: programlisting 2802#: reference_operator.xml:1713 2803#, no-c-format 2804msgid "" 2805"-- Save a literal query trajectory in a psql variable...\n" 2806"\\set qt 'ST_AddMeasure(ST_MakeLine(ST_MakePointM(-350,300,0)," 2807"ST_MakePointM(-410,490,0)),10,20)'\n" 2808"-- Run the query !\n" 2809"SELECT track_id, dist FROM (\n" 2810" SELECT track_id, ST_DistanceCPA(tr,:qt) dist\n" 2811" FROM trajectories\n" 2812" ORDER BY tr |=| :qt\n" 2813" LIMIT 5\n" 2814") foo;\n" 2815" track_id dist\n" 2816"----------+-------------------\n" 2817" 395 | 0.576496831518066\n" 2818" 380 | 5.06797130410151\n" 2819" 390 | 7.72262293958322\n" 2820" 385 | 9.8004461358071\n" 2821" 405 | 10.9534397988433\n" 2822"(5 rows)" 2823msgstr "" 2824"-- psql変数にリテラルクエリのトラジェクトリを保存\n" 2825"\\set qt 'ST_AddMeasure(ST_MakeLine(ST_MakePointM(-350,300,0)," 2826"ST_MakePointM(-410,490,0)),10,20)'\n" 2827"-- クエリを実行\n" 2828"SELECT track_id, dist FROM (\n" 2829" SELECT track_id, ST_DistanceCPA(tr,:qt) dist\n" 2830" FROM trajectories\n" 2831" ORDER BY tr |=| :qt\n" 2832" LIMIT 5\n" 2833") foo;\n" 2834" track_id dist\n" 2835"----------+-------------------\n" 2836" 395 | 0.576496831518066\n" 2837" 380 | 5.06797130410151\n" 2838" 390 | 7.72262293958322\n" 2839" 385 | 9.8004461358071\n" 2840" 405 | 10.9534397988433\n" 2841"(5 rows)" 2842 2843#. Tag: para 2844#: reference_operator.xml:1717 2845#, no-c-format 2846msgid "" 2847", <xref linkend=\"ST_ClosestPointOfApproach\"/>, <xref linkend=" 2848"\"ST_IsValidTrajectory\"/>" 2849msgstr "" 2850", <xref linkend=\"ST_ClosestPointOfApproach\"/>, <xref linkend=" 2851"\"ST_IsValidTrajectory\"/>" 2852 2853#. Tag: refname 2854#: reference_operator.xml:1727 2855#, no-c-format 2856msgid "<#>" 2857msgstr "<#>" 2858 2859#. Tag: refpurpose 2860#: reference_operator.xml:1729 2861#, no-c-format 2862msgid "Returns the 2D distance between A and B bounding boxes." 2863msgstr "" 2864"AのバウンディングボックスとBのバウンディングボックスの2次元距離を返します。" 2865 2866#. Tag: funcprototype 2867#: reference_operator.xml:1736 2868#, no-c-format 2869msgid "" 2870"<funcdef>double precision <function><#></function></funcdef> " 2871"<paramdef> <type>geometry </type> <parameter>A</parameter> </paramdef> " 2872"<paramdef> <type>geometry </type> <parameter>B</parameter> </paramdef>" 2873msgstr "" 2874"<funcdef>double precision <function><#></function></funcdef> " 2875"<paramdef> <type>geometry </type> <parameter>A</parameter> </paramdef> " 2876"<paramdef> <type>geometry </type> <parameter>B</parameter> </paramdef>" 2877 2878#. Tag: para 2879#: reference_operator.xml:1757 2880#, no-c-format 2881msgid "" 2882"The <varname><#></varname> operator returns distance between two " 2883"floating point bounding boxes, possibly reading them from a spatial index " 2884"(PostgreSQL 9.1+ required). Useful for doing nearest neighbor <emphasis role=" 2885"\"strong\">approximate</emphasis> distance ordering." 2886msgstr "" 2887"<varname><#></varname>演算子は二つの浮動小数点数によるバウンディング" 2888"ボックス間の距離を返します。可能なら空間インデクス (PostgreSQL 9.1以上が必要" 2889"です)を読みます。近傍の<emphasis role=\"strong\">概ねの</emphasis>距離による" 2890"並び替えに使います。" 2891 2892#. Tag: para 2893#: reference_operator.xml:1759 reference_operator.xml:1878 2894#, no-c-format 2895msgid "" 2896"This operand will make use of any indexes that may be available on the " 2897"geometries. It is different from other operators that use spatial indexes in " 2898"that the spatial index is only used when the operator is in the ORDER BY " 2899"clause." 2900msgstr "" 2901"これのオペランドはジオメトリで利用できるインデクスを使用します。他の演算子と" 2902"の相違点は、ORDER BY句でのみインデクスが使用される点です。" 2903 2904#. Tag: para 2905#: reference_operator.xml:1762 2906#, no-c-format 2907msgid "" 2908"Index only kicks in if one of the geometries is a constant e.g. ORDER BY " 2909"(ST_GeomFromText('POINT(1 2)') <#> geom) instead of g1.geom <#>." 2910msgstr "" 2911"ジオメトリのひとつがg1.geom <#>と違って ORDER BY " 2912"(ST_GeomFromText('POINT(1 2)') <#> geom)というように定数である場合に" 2913"は、インデクスが有効になるだけです。" 2914 2915#. Tag: para 2916#: reference_operator.xml:1764 2917#, no-c-format 2918msgid "Availability: 2.0.0 -- KNN only available for PostgreSQL 9.1+" 2919msgstr "Availability: 2.0.0 PostgreSQL 9.1以上でのみ有効です。" 2920 2921#. Tag: programlisting 2922#: reference_operator.xml:1770 2923#, no-c-format 2924msgid "" 2925"<![CDATA[SELECT *\n" 2926"FROM (\n" 2927"SELECT b.tlid, b.mtfcc,\n" 2928" b.geom <#> ST_GeomFromText('LINESTRING(746149 2948672,745954 " 2929"2948576,\n" 2930" 745787 2948499,745740 2948468,745712 2948438,\n" 2931" 745690 2948384,745677 2948319)',2249) As b_dist,\n" 2932" ST_Distance(b.geom, ST_GeomFromText('LINESTRING(746149 " 2933"2948672,745954 2948576,\n" 2934" 745787 2948499,745740 2948468,745712 2948438,\n" 2935" 745690 2948384,745677 2948319)',2249)) As act_dist\n" 2936" FROM bos_roads As b\n" 2937" ORDER BY b_dist, b.tlid\n" 2938" LIMIT 100) As foo\n" 2939" ORDER BY act_dist, tlid LIMIT 10;]]>\n" 2940"\n" 2941" tlid | mtfcc | b_dist | act_dist\n" 2942"-----------+-------+------------------+------------------\n" 2943" 85732027 | S1400 | 0 | 0\n" 2944" 85732029 | S1400 | 0 | 0\n" 2945" 85732031 | S1400 | 0 | 0\n" 2946" 85734335 | S1400 | 0 | 0\n" 2947" 85736037 | S1400 | 0 | 0\n" 2948" 624683742 | S1400 | 0 | 128.528874268666\n" 2949" 85719343 | S1400 | 260.839270432962 | 260.839270432962\n" 2950" 85741826 | S1400 | 164.759294123275 | 260.839270432962\n" 2951" 85732032 | S1400 | 277.75 | 311.830282365264\n" 2952" 85735592 | S1400 | 222.25 | 311.830282365264\n" 2953"(10 rows)" 2954msgstr "" 2955"<![CDATA[SELECT *\n" 2956"FROM (\n" 2957"SELECT b.tlid, b.mtfcc,\n" 2958" b.geom <#> ST_GeomFromText('LINESTRING(746149 2948672,745954 " 2959"2948576,\n" 2960" 745787 2948499,745740 2948468,745712 2948438,\n" 2961" 745690 2948384,745677 2948319)',2249) As b_dist,\n" 2962" ST_Distance(b.geom, ST_GeomFromText('LINESTRING(746149 " 2963"2948672,745954 2948576,\n" 2964" 745787 2948499,745740 2948468,745712 2948438,\n" 2965" 745690 2948384,745677 2948319)',2249)) As act_dist\n" 2966" FROM bos_roads As b\n" 2967" ORDER BY b_dist, b.tlid\n" 2968" LIMIT 100) As foo\n" 2969" ORDER BY act_dist, tlid LIMIT 10;]]>\n" 2970"\n" 2971" tlid | mtfcc | b_dist | act_dist\n" 2972"-----------+-------+------------------+------------------\n" 2973" 85732027 | S1400 | 0 | 0\n" 2974" 85732029 | S1400 | 0 | 0\n" 2975" 85732031 | S1400 | 0 | 0\n" 2976" 85734335 | S1400 | 0 | 0\n" 2977" 85736037 | S1400 | 0 | 0\n" 2978" 624683742 | S1400 | 0 | 128.528874268666\n" 2979" 85719343 | S1400 | 260.839270432962 | 260.839270432962\n" 2980" 85741826 | S1400 | 164.759294123275 | 260.839270432962\n" 2981" 85732032 | S1400 | 277.75 | 311.830282365264\n" 2982" 85735592 | S1400 | 222.25 | 311.830282365264\n" 2983"(10 rows)" 2984 2985#. Tag: para 2986#: reference_operator.xml:1774 2987#, no-c-format 2988msgid "" 2989", <xref linkend=\"ST_Distance\"/>, <xref linkend=\"geometry_distance_knn\"/>" 2990msgstr "" 2991", <xref linkend=\"ST_Distance\"/>, <xref linkend=\"geometry_distance_knn\"/>" 2992 2993#. Tag: refname 2994#: reference_operator.xml:1780 2995#, no-c-format 2996msgid "<<->>" 2997msgstr "<<->>" 2998 2999#. Tag: refpurpose 3000#: reference_operator.xml:1782 3001#, no-c-format 3002msgid "" 3003"Returns the n-D distance between the centroids of A and B bounding boxes." 3004msgstr "" 3005"AのバウンディングボックスとBのバウンディングボックスのn次元距離を返します。" 3006 3007#. Tag: funcprototype 3008#: reference_operator.xml:1790 3009#, no-c-format 3010msgid "" 3011"<funcdef>double precision <function><<->></function></funcdef> " 3012"<paramdef> <type>geometry </type> <parameter>A</parameter> </paramdef> " 3013"<paramdef> <type>geometry </type> <parameter>B</parameter> </paramdef>" 3014msgstr "" 3015"<funcdef>double precision <function><<->></function></funcdef> " 3016"<paramdef> <type>geometry </type> <parameter>A</parameter> </paramdef> " 3017"<paramdef> <type>geometry </type> <parameter>B</parameter> </paramdef>" 3018 3019#. Tag: para 3020#: reference_operator.xml:1811 3021#, no-c-format 3022msgid "" 3023"The <varname><<->></varname> operator returns the n-D " 3024"(euclidean) distance between the centroids of the bounding boxes of two " 3025"geometries. Useful for doing nearest neighbor <emphasis role=\"strong" 3026"\">approximate</emphasis> distance ordering." 3027msgstr "" 3028"<varname><<->></varname>演算子は、二つのジオメトリのバウンディン" 3029"グボックスの重心のn次元 (ユークリッド)距離を返します。近傍の<emphasis role=" 3030"\"strong\">概ねの</emphasis>距離による並び替えに使います。" 3031 3032#. Tag: para 3033#: reference_operator.xml:1818 3034#, no-c-format 3035msgid "" 3036"This operand will make use of n-D GiST indexes that may be available on the " 3037"geometries. It is different from other operators that use spatial indexes in " 3038"that the spatial index is only used when the operator is in the ORDER BY " 3039"clause." 3040msgstr "" 3041"これのオペランドはジオメトリで利用できるインデクスを使用します。他の演算子と" 3042"の相違点は、ORDER BY句でのみインデクスが使用される点です。" 3043 3044#. Tag: para 3045#: reference_operator.xml:1830 reference_operator.xml:1887 3046#, no-c-format 3047msgid "Availability: 2.2.0 -- KNN only available for PostgreSQL 9.1+" 3048msgstr "Availability: 2.0.0 KNNはPostgreSQL 9.1以上でのみ有効です。" 3049 3050#. Tag: para 3051#: reference_operator.xml:1837 3052#, no-c-format 3053msgid ", <xref linkend=\"geometry_distance_knn\"/>" 3054msgstr ", <xref linkend=\"geometry_distance_knn\"/>" 3055 3056#. Tag: refname 3057#: reference_operator.xml:1846 3058#, no-c-format 3059msgid "<<#>>" 3060msgstr "<<#>>" 3061 3062#. Tag: refpurpose 3063#: reference_operator.xml:1848 3064#, no-c-format 3065msgid "Returns the n-D distance between A and B bounding boxes." 3066msgstr "" 3067"AのバウンディングボックスとBのバウンディングボックスのn次元距離を返します。" 3068 3069#. Tag: funcprototype 3070#: reference_operator.xml:1855 3071#, no-c-format 3072msgid "" 3073"<funcdef>double precision <function><<#>></function></funcdef> " 3074"<paramdef> <type>geometry </type> <parameter>A</parameter> </paramdef> " 3075"<paramdef> <type>geometry </type> <parameter>B</parameter> </paramdef>" 3076msgstr "" 3077"<funcdef>double precision <function><<#>></function></funcdef> " 3078"<paramdef> <type>geometry </type> <parameter>A</parameter> </paramdef> " 3079"<paramdef> <type>geometry </type> <parameter>B</parameter> </paramdef>" 3080 3081#. Tag: para 3082#: reference_operator.xml:1876 3083#, no-c-format 3084msgid "" 3085"The <varname><<#>></varname> operator returns distance between " 3086"two floating point bounding boxes, possibly reading them from a spatial " 3087"index (PostgreSQL 9.1+ required). Useful for doing nearest neighbor " 3088"<emphasis role=\"strong\">approximate</emphasis> distance ordering." 3089msgstr "" 3090"<varname><<#>></varname>演算子は二つの浮動小数点数バウンディング" 3091"ボックスの距離を返します。可能なら空間インデクス (PostgreSQL 9.1以上が必要で" 3092"す)を読みます。近傍の<emphasis role=\"strong\">概ねの</emphasis>距離による並" 3093"び替えに使います。" 3094 3095#. Tag: para 3096#: reference_operator.xml:1881 3097#, no-c-format 3098msgid "" 3099"Index only kicks in if one of the geometries is a constant e.g. ORDER BY " 3100"(ST_GeomFromText('POINT(1 2)') <<#>> geom) instead of g1.geom " 3101"<<#>>." 3102msgstr "" 3103"ジオメトリの一つがg1.geom <<#>>.と違ってORDER BY " 3104"(ST_GeomFromText('POINT(1 2)') <<#>> geom)といった定数である場合" 3105"には、インデクスが有効になるだけです。" 3106 3107#. Tag: para 3108#: reference_operator.xml:1893 3109#, no-c-format 3110msgid ", <xref linkend=\"geometry_distance_box\"/>" 3111msgstr ", <xref linkend=\"geometry_distance_box\"/>" 3112 3113#~ msgid "" 3114#~ "Returns <varname>TRUE</varname> if A's bounding box is the same as B's. " 3115#~ "Uses double precision bounding box." 3116#~ msgstr "" 3117#~ "AのバウンディングボックスがBのバウンディングボックスと同じ場合に" 3118#~ "<varname>TRUE</varname>を返します。倍精度浮動小数点数のバウンディングボッ" 3119#~ "クスを使います。" 3120 3121#~ msgid "" 3122#~ "This is cause for a lot of confusion. When you compare geometryA = " 3123#~ "geometryB it will return true even when the geometries are clearly " 3124#~ "different IF their bounding boxes are the same. To check for true " 3125#~ "equality use <xref linkend=\"ST_OrderingEquals\"/> or <xref linkend=" 3126#~ "\"ST_Equals\"/>" 3127#~ msgstr "" 3128#~ "これは多数の混乱の元です。geometryA = geometryBの比較を行うと、ジオメトリ" 3129#~ "が明確に異なっていたとしても、バウンディングボックスが同じならTRUEが返りま" 3130#~ "す。本当の等価性をチェックするには<xref linkend=\"ST_OrderingEquals\"/>ま" 3131#~ "たは<xref linkend=\"ST_Equals\"/>を使います。" 3132 3133#~ msgid "" 3134#~ "Changed: 2.0.0 , the bounding box of geometries was changed to use double " 3135#~ "precision instead of float4 precision of prior. The side effect of this " 3136#~ "is that in particular points in prior versions that were a little " 3137#~ "different may have returned true in prior versions and false in 2.0+ " 3138#~ "since their float4 boxes would be the same but there float8 (double " 3139#~ "precision), would be different." 3140#~ msgstr "" 3141#~ "Changed: 2.0.0 ジオメトリのバウンディングボックスをfloat4使用から倍精度使" 3142#~ "用に変更しました。ほんの少し違う位置にある特定のポイントについて、float4で" 3143#~ "のバウンディングボックスなら同じになるのにfloat8 (倍精度)でのバウンディン" 3144#~ "グボックスでは異なるため、以前の版ではtrueが返ったのが2.0以上ではfalseが返" 3145#~ "る、という副作用があります。" 3146 3147#~ msgid ", <xref linkend=\"ST_OrderingEquals\"/>" 3148#~ msgstr ", <xref linkend=\"ST_OrderingEquals\"/>" 3149 3150#~ msgid "" 3151#~ "The above can be used to test if you have the new or old behavior of ~= " 3152#~ "operator." 3153#~ msgstr "上の例は、~=演算子の新しい挙動でも古い挙動でも使えます。" 3154 3155#~ msgid "" 3156#~ "The <varname>|>></varname> operator returns <varname>TRUE</varname> " 3157#~ "if the bounding box of geometry A is strictly to the right of the " 3158#~ "bounding box of geometry B." 3159#~ msgstr "" 3160#~ "<varname>|>></varname>演算子は、Aのバウンダリボックスが、厳密にBのバ" 3161#~ "ウンダリボックスの上にある場合に<varname>TRUE</varname>を返します。" 3162