[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