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