[postgis-users] Querying geometries with different srid

[Farrukh Najmi]

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<farrukh at 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>


-- 
Regards,
Farrukh Najmi

Web: http://www.wellfleetsoftware.com