Hi all At the first time i used ST_Contains but it take a long time, so I used ST_Dwithin to improve the performance for the query statement but i don't know it is correct or not. I would like to know my points are within in polygon or not:
SELECT id, geom FROM my_neighbour WHERE ST_Dwithin (geom, *geometry*, *0.00001*) *geometry:* is a polygon(input parameter). *0.00001:* I means the radius of *geometry* is 1 meters, is it right? 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.ngu...@axonactive.net / liemnguye...@gmail.com Web Site : http://axonactive.vn Address : 87 Thang Long Street,Gate 2 Ward 4, Tan Binh District, HCM city, Vietnam.
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users