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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to