Assuming your box is in the same srid as your points. It would be
something like
SELECT *
FROM pointdemo
WHERE the_point && setsrid('BOX(295149 2315499, 465992
2163790)'::box2d, -1)
Note - above I am assuming your point geometry is called the_point and
your SRID is -1
If the srid of your point geometry is not -1 then change -1 to what it
should be.
-----Original Message-----
From:
postgis-users-bounces@...
[mailto:
postgis-users-bounces@...] On Behalf Of
anhtin
Sent: Tuesday, April 10, 2007 6:18 AM
To:
postgis-users@...
Subject: [postgis-users] Select Point or PolyGon Polyline in Box
hi all
i have question to postgis
i have table Pointdemo
I want select all point in my Box("Rectangle") on PostGis
my box is corrdinate
ex: full extend is:Box(110638 2587481, 903350 1972446) ---> xmin ymin,
xmax
ymax
i want select point in Box(295149 2315499, 465992 2163790) ---> xmin
ymin,
xmax ymax
How will i do that ?????
--
View this message in context:
http://www.nabble.com/Select-Point-or-PolyGon-Polyline-in-Box-tf3552167.
html#a9916986
Sent from the PostGIS - User mailing list archive at Nabble.com.
_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users
