[postgis-users] Whats wrong with my query?

[Thomas, Cord]

your or clause's should be parenthetically set apart.

-----Original Message-----
From: Guido Staub [mailto:guidostaub at lycos.de]
Sent: Tuesday, December 17, 2002 11:37 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Whats wrong with my query?


  Hi all,

can somebody tell me what's wrong with my query?
SELECT pol.the_geom as pgeo,cc.the_geom as ccgeo
from polygons pol,CompleteChain
cc where pol.the_geom && GeometryFromText ('POINT(-161.893119
55.560754)',4326) or cc.the_geom && GeometryFromText
('POINT(-161.893119 55.560754)',4326);

When I do them seperately the first one (Polygon && Point) returns one 
row and the other (CompleteChain && Point) no row. But if I do the query 
above I'm running out of memory. I only want to know which BBox of 
Polygons overlaps the specified point and which BBox of CompleteChain 
overlaps that point?

Thanks
Guido Staub


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users