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

PostGIS trac at osgeo.org
Thu Oct 15 06:58:43 PDT 2009


#269: Geometry -> Geography autocast causes && operator query to fail
-----------------------+----------------------------------------------------
  Reporter:  mcayland  |       Owner:  pramsey      
      Type:  defect    |      Status:  closed       
  Priority:  medium    |   Milestone:  postgis 1.5.0
 Component:  postgis   |     Version:               
Resolution:  invalid   |    Keywords:               
-----------------------+----------------------------------------------------
Changes (by robe):

  * status:  new => closed
  * resolution:  => invalid

Comment:

 Mark,
 I consider this bug invalid and not a bug.  I don't personally see this as
 an issue because how would it know -- If people exercise this it will be

 geography && unknown

 geometry && unknown

 In which case the operation is not ambiguous.  In your case you are
 clearly doing a

 geometry && geography which is a big no no in my book.  And you should be
 slapped on the wrist for even attempting such a silly thing :)

 for example the below works perfectly fine.

 {{{
 SELECT name
 FROM neighborhoods
 WHERE geography(ST_Transform(the_geom,4326)) && 'POINT(-71.0155762507496
 42.3724551968706)'
 }}}

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


More information about the postgis-devel mailing list