I have created a ticket in issue tracker for this issue here:
http://trac.osgeo.org/postgis/ticket/771
On 01/14/2011 09:55 AM, Farrukh Najmi wrote:
BTW, using nested SELECT did not work either as shown in follow query:
SELECT * FROM GeometryValueType gvt WHERE
ST_SRID(gvt.geometry) = 4326 AND gvt.id IN (
SELECT gvt1.id FROM GeometryValueType gvt1 WHERE
within(gvt1.geometry, ST_GeomFromText('POLYGON((-100 0, 0 0, 0
100, -100 100, -100 0))', 4326)) = true
)
It again gives the "Operation on mixed SRID geometries" error :-(
It seems to me that surely this should be doable. If it is not doable,
do folks think that is an issue that should be tracked?
On 01/14/2011 09:49 AM, Farrukh Najmi wrote:
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
