[postgis-users] (no subject)

[eehab hamzeh]

thanks for your replay, do you mean to add some like this, i keep receiving error

CREATE TABLE example_intersections_b AS (select id, 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
);

kind regards

ihab
  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
> );
>

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

You don't need anything complicated here. Just add your ids directly in your
SELECT query.

Emilie Laffray

 		 	   		  
_________________________________________________________________
Drag n’ drop—Get easy photo sharing with Windows Live™ Photos.

http://www.microsoft.com/windows/windowslive/products/photos.aspx
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090929/b5e0f916/attachment.html>