[postgis-users] Whats wrong with my query?

[staub at gik.uni-karlsruhe.de]

I've tried it, but there is still no success.
Now my query looks like:

SELECT pol.the_geom as polgeo,cc.the_geom as ccgeo from Polygons
pol,CompleteChain cc where (pol.the_geom && GeometryFromText
('POINT(-165.893119 55.560754)',4326))
or
(cc.the_geom && GeometryFromText('POINT(-161.893119 55.560754)',4326));

Or did I misunderstand your suggestion? If so, any help is welcome!

"Thomas, Cord" wrote:

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