On 28 October 2010 10:00, trevor1940 wrote:
>
> Hi
>
> I have a PostGIS table and I wish to get the location/name of multiple
> points at once the command for selecting one point is
>
> select PolyName from MyPolygones where st_Contains(the_geom,
> GeomFromText('point($LAT $LONG)4326');
>
> where
: 28.10.10 10:00 Uhr
An: pgsql-general@postgresql.org
Betreff: [GENERAL] PostGIS return multiple points
Hi I have a PostGIS table and I wish to get the location/name of multiple
points at once the command for selecting one point is select PolyName from
MyPolygones where st_Contains(the_geom
hey,
I haven't used postgis yet, however,
assuming the normal rules still apply and st_Contains returns
true/false:
SELECT ... WHERE st_Contains(point1) OR st_Contains(point2) OR ...
or using the IN statement:
SELECT ... WHERE true IN (st_Contains(point1),st_Contains(point2),...)
That should g
Hi
I have a PostGIS table and I wish to get the location/name of multiple
points at once the command for selecting one point is
select PolyName from MyPolygones where st_Contains(the_geom,
GeomFromText('point($LAT $LONG)4326');
where $LAT $LONG are perl varables
So how can i do this if iI have