[postgis-devel] [PostGIS] #2035: Strange behavior when using left (<<) and right (>>) operators.

[PostGIS]

#2035: Strange behavior when using left (<<) and right (>>) operators.
---------------------------------+------------------------------------------
 Reporter:  jbronn               |       Owner:  pramsey      
     Type:  defect               |      Status:  new          
 Priority:  medium               |   Milestone:  PostGIS 2.0.2
Component:  postgis              |     Version:  2.0.x        
 Keywords:  left right operator  |  
---------------------------------+------------------------------------------

Comment(by pramsey):

 No particular surprise, the difference is that the LIMIT forces the query
 plan into a sequence scan rather than an index scan, so the difference is
 due to different behaviour between those modes. So, new mystery: why the
 difference?

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