[postgis-devel] [PostGIS] #269: Geometry -> Geography autocast causes && operator query to fail

PostGIS trac at osgeo.org
Thu Oct 15 06:51:50 PDT 2009


#269: Geometry -> Geography autocast causes && operator query to fail
----------------------+-----------------------------------------------------
 Reporter:  mcayland  |       Owner:  pramsey      
     Type:  defect    |      Status:  new          
 Priority:  medium    |   Milestone:  postgis 1.5.0
Component:  postgis   |     Version:               
 Keywords:            |  
----------------------+-----------------------------------------------------
 This is bad:

 trunk=# explain analyze select count(*) from cities where the_geog &&
 ST_SetSRID(ST_GeographyFromText('POLYGON((0 0, 0 1, 1 1, 1 0, 0 0))'),
 4326);

 ERROR:  operator is not unique: geography && geometry
 LINE 1: ...nalyze select count(*) from cities where the_geog && ST_SetS...

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/269>
PostGIS <http://trac.osgeo.org/postgis/>
PostGIS


More information about the postgis-devel mailing list