<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
thanks for your replay, do you mean to add some like this, i keep receiving error<br><br>CREATE TABLE example_intersections_b AS (select id, 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>kind regards<br><br>ihab<br><pre><i> hello all,<br></i>><i><br></i>><i> I need to know the id of the object that are intersect, i use the following<br></i>><i> query. can any body help to develop it to contain the id.<br></i>><i><br></i>><i><br></i>><i> CREATE TABLE example_intersections_b AS (<br></i>><i> SELECT DISTINCT st_intersects(part_1.the_geom, part_2.the_geom)<br></i>><i> FROM source AS part_1,<br></i>><i> faces_obj AS part_2<br></i>><i> WHERE part_1.id <> part_2.id<br></i>><i> );<br></i>><i><br></i><br>CREATE TABLE example_intersections_b AS<br>(<br> SELECT DISTINCT st_intersects(part_1.the_geom, part_2.the_geom),<br> part_1.id,<br> part_2.id<br> FROM source AS part_1,<br> faces_obj AS part_2<br> WHERE part_1.id <> part_2.id<br>);<br><br>You don't need anything complicated here. Just add your ids directly in your<br>SELECT query.<br><br>Emilie Laffray<br></pre><br> <br /><hr />What can you do with the new Windows Live? <a href='http://www.microsoft.com/windows/windowslive/default.aspx' target='_new'>Find out</a></body>
</html>