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