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