[postgis-tickets] [PostGIS] #3131: KNN geography still gives ERROR: index returned tuples in wrong order

PostGIS trac at osgeo.org
Sun May 31 10:36:20 PDT 2015


#3131: KNN geography still gives  ERROR:  index returned tuples in wrong order
----------------------+---------------------------
  Reporter:  robe     |      Owner:  pramsey
      Type:  defect   |     Status:  reopened
  Priority:  blocker  |  Milestone:  PostGIS 2.2.0
 Component:  postgis  |    Version:  trunk
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by pramsey):

 Change the docs. <-> will only return sphere distance, it is required to
 be that way to harmonize the way the key test in hte index calculates
 distance with how the "exact" operator tests. <-> should only be used for
 ordering, not measuring, if you want a distance, use ST_Distance, that's
 what the docs should say

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3131#comment:14>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-tickets mailing list