Hi Ture,
Thanks for the advice. Unfortunately WITH is not supported in postgres
8.3. So I could not try it out.
Any other ideas?
On 01/14/2011 12:38 AM, Ture Pålsson wrote:
2011/1/14 Farrukh Najmi<farr...@wellfleetsoftware.com>:
--Gives Error: Operation on mixed geometries
SELECT * FROM GeometryValueType gvt WHERE ( ST_SRID(gvt.geometry) = 4326
AND
within(gvt.geometry, ST_GeomFromText('POLYGON((-100 0, 0 0, 0 100, -100
100, -100 0))', 4326)) = true )
Does SQL guarantee left-to-right evaluation and short-circuiting of
AND checks the way that C does? I must confess I have no clue.
However, if it doesn't, that might be what's causing your headaches.
I'd try moving the SRID filter into a WITH construct or a sub-select
just to see what happens:
WITH filteredgeom AS (
SELECT * FROM gvt WHERE ST_SRID(geometry) = 4326)
SELECT * FROM filteredgeom WHERE within(geometry, ...) ;
Probably lots of syntax errors (haven't had breakfast yet) but you get
the idea...
-- Ture
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Regards,
Farrukh Najmi
Web: http://www.wellfleetsoftware.com
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
