[postgis-devel] [PostGIS] #536: Get rid of the STRICT on geography ST_Intersects

[PostGIS]

#536: Get rid of the STRICT on geography ST_Intersects
---------------------+------------------------------------------------------
 Reporter:  robe     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  high     |   Milestone:  PostGIS 1.5.2
Component:  postgis  |     Version:  1.5.X        
 Keywords:           |  
---------------------+------------------------------------------------------
 The STRICT clause on the ST_Intersects geography is preventing the planner
 from dissolving the function into the index + non-index constituent parts.

 This means it is never using the index.  Removing the STRICT clause seems
 to fix that.

 See thread
 http://postgis.refractions.net/pipermail/postgis-users/2010-
 May/026831.html

 Haven't checked the other geography functions to see if they suffer the
 same issue.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/536>
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.