<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
hello all,<br><br>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.<br><br><br>CREATE TABLE example_intersections_b AS (<br> SELECT DISTINCT st_intersects(part_1.the_geom, part_2.the_geom)<br> FROM source AS part_1,<br> faces_obj AS part_2<br> WHERE part_1.id <> part_2.id<br>);<br><br><br>thanks<br>ihab<br><br><br><img alt=""><img alt=""><img alt=""><br><br> <br /><hr />Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! <a href='http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us' target='_new'>Try it!</a></body>
</html>