[postgis-users] Whats wrong with my query?

[Guido Staub]

  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