Coordinates of a rectangle, you mean of thé points at the corners ?

You should try st_makepolygon(st_makeline()) or st_makeenvelope.

Postgis manual is very useful, you should also try it to learn how these 
function work and which one is tthe better one for you

Hugues


----- Message d'origine--------
De: postgis-users-boun...@postgis.refractions.net de la part de Ed Linde
Date:7/2012 14
À: PostGIS Users Discussion
Objet : [postgis-users] Bounding Box intersection
 
Hi All,
I have a table with linestring geometries, and I have the co-ordinates of a
rectangle/ bounding box.
I want to get only a restricted set of geometries that lie within or
intersect with this box. Is there a
way to construct this box on the fly and get only the relevant set of
geometries?

Cheers,o
Ed

<<winmail.dat>>

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

Reply via email to