PostGIS return multiple points

From: trevor1940 <antonys(at)nsom(dot)org(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: PostGIS return multiple points
Date: 2010-10-28 08:00:38
Message-ID: 1288252838872-3240107.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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 100 points without hitting the database 100
times?

--
View this message in context: http://postgresql.1045698.n5.nabble.com/PostGIS-return-multiple-points-tp3240107p3240107.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hfe80 2010-10-28 08:13:04 Re: DB become enormous with continuos insert and update
Previous Message Oluwatope Akinniyi 2010-10-28 07:30:52 Hello, my dear friends: