[postgis-tickets] [PostGIS] #2556: ST_Intersects results depending on insert order

[PostGIS]

#2556: ST_Intersects results depending on insert order
--------------------------------------------------+-------------------------
 Reporter:  gekorob                               |       Owner:  pramsey      
     Type:  defect                                |      Status:  new          
 Priority:  high                                  |   Milestone:  PostGIS 2.1.2
Component:  postgis                               |     Version:  2.1.x        
 Keywords:  st_intersects intersection geography  |  
--------------------------------------------------+-------------------------

Comment(by gekorob):

 Thank you for your prompt answer, we tested the two native distance
 functions on our full database (approx 6 milions of images).
 The answers were correct and the time comparable with the workaround we
 implemented using st_intersects in union with st_contains (as we found
 that the problem is where one of the two geometries is completely
 contained in the other one).

 To answer your first question about the behavior in postgis version 2.0.x,
 the results were correct and the query not so time consuming.

 Thank you again for your time
 bye
    Roby

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2556#comment:3>
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.