Hi Ed,
Yeah, I would suggest to use ST_MakeEnvelope (which was also one of the
suggestions by Francois Hugues).
The query would look something like this:
SELECT * FROM myschema.mylinestringtable WHERE ST_Intersects(geom,
ST_MakeEnvelope(155000, 463000, 156000, 464000, 28992));
N.B. The fifht
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-
