[postgis-devel] [PostGIS] #701: Support for 9.1 KNN GIST enhancements

PostGIS trac at osgeo.org
Mon Sep 26 13:42:38 PDT 2011


#701: Support for 9.1 KNN GIST enhancements
-------------------------+--------------------------------------------------
 Reporter:  robe         |       Owner:  pramsey      
     Type:  enhancement  |      Status:  new          
 Priority:  medium       |   Milestone:  PostGIS 2.0.0
Component:  postgis      |     Version:  trunk        
 Keywords:               |  
-------------------------+--------------------------------------------------

Comment(by pramsey):

 First cut is in at r7894.

 The <-> operator is now a distance operator. It returns the squared
 distance between the centroids of the objects.

 Example getting 10 nearest named points from a names table.
 {{{
   SELECT name,ST_AsText(geom)
   FROM geonames
   ORDER BY geom <-> ST_SetSRID(ST_MakePoint(-90,40),4326)
   LIMIT 10;
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/701#comment:5>
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-devel mailing list