[postgis-users] intersection

[eehab hamzeh]

hello all,

I need to know the id of the object that are intersect, i use the following query. can any body help to develop it to contain the id.


CREATE TABLE example_intersections_b AS (
    SELECT  DISTINCT st_intersects(part_1.the_geom, part_2.the_geom)
      FROM  source AS part_1,
           faces_obj AS part_2
     WHERE part_1.id <> part_2.id
);


thanks
ihab




 		 	   		  
_________________________________________________________________
Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy!
http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090929/61b1ddbb/attachment.html>