[postgis-users] using "&&" oprerator

[nguyen liem]

Hi All, i'm a newbie with postgis and probably this is an easy question.

As I know "&&" operator which is used for checking 1 geometry is overlap on
another or not.
Could I check 1 point is overlap on 1 polygon by the query bellow ?

SELECT  f.point_id, s.zip_id
FROM  points f, zips s
WHERE ST_SetSRID(ST_MakePoint(f.longitude, f.latitude),4326) && s.zip_polygon;

Does anything wrong here? Or could you give me other ways to check 1
point is within in 1 polygon or not?

Cheers.
-- 
Liem Nguyen
Developer
Axon Active Corp.
----------------------------------------------------------------------------
Direct Line      : +84 38 948 4645
Fax                  : +84 38 811 3489
Mobile Phone  : +84 168 994 8897
Skype ID         : liemnguyendl2204
Email               : liem.nguyen at axonactive.net / liemnguyendl at gmail.com
Web Site          : http://axonactive.vn
Address           : 87 Thang Long Street,Gate 2 Ward 4,
                         Tan Binh District, HCM city, Vietnam.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100510/747c47c3/attachment.html>