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

PostGIS trac at osgeo.org
Mon Oct 8 12:03:15 PDT 2012

#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  |  
 During the process of adding PostGIS support for !GeoDjango, I came across
 a regression in my test suite when using the left and right operators.

 Specifically, when querying a spatial table (or using `COUNT(*)`) using
 the left (`<<`) or right (`>>`) operators, no results are returned.
 However, when a `LIMIT` is added to the query it works.

 Attached to this ticket is SQL that demonstrates this issue; I've
 confirmed on Ubuntu 12.04 (Postgres 9.1.5, GEOS 3.2.2, PostGIS 2.0.1) and
 on my Mac (Postgres 9.2.1, GEOS 3.3.5, PostGIS 2.0.1).

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