[postgis] How can I find which points are contained in a polygon?

[gregoryliapis]

Hi all,
I am now starting using PostGIS after having experimented with 
PostgreSQL. My problem is that I need a query to find which cities 
(points) are contained in a specific country (polygon). Although I 
managed to do that with PostgreSQL with types 'point' 
and 'polygon'and the operator '&&', I can't find the answer 
using 'geometry' in PostGIS.I can only find cities within the 
bounding box of a country, something quite useless. 
Could anyone help me?

Greg Liapis
Thessaloniki
GREECE


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Pinpoint the right security solution for your company- Learn how to add 128- bit encryption and to authenticate your web site with VeriSign's FREE guide!
http://us.click.yahoo.com/yQix2C/33_CAA/yigFAA/PhFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/