[postgis-users] I need to select all featcher touch one polygon (eehab hamzeh)

[eehab hamzeh]

Hello every body,



can any body help me to write sql statment that select all the polygons that touch polygons in the same feature class.
i try to do it in as below and find all polygon that are within 100 m from the polygon 2.

SELECT the_geom FROM "public"."IGFPLAN"
WHERE "Id" = '2' and distance(the_geom, the_geom) < 100


Thanks

ihab


_________________________________________________________________
Explore the seven wonders of the world
http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080808/2c449c52/attachment.html>