From: Emilie Laffray <emilie.laffray@gmail.com>
Date: Tue, 29 Sep 2009 19:36:25 +0100
Subject: [postgis-users] (no subject)
In-Reply-To: <SNT113-W4279207C375549AD79B92EA0D50@phx.gbl>
References: <SNT113-W4279207C375549AD79B92EA0D50@phx.gbl>
Message-ID: <4AC253A9.60906@gmail.com>

eehab hamzeh wrote:
> 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
> );

Your query is not valid. Your double select is not valid SQL. This
should be the valid sequence. Obviously, I don't have your table
structure, but in theory this should work.

CREATE TABLE example_intersections_b AS 
(        SELECT      DISTINCT
                               part_1.id,
                               part_2.id,
                               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
);

Plus you may want to give the error you are getting to be helped in a
more efficient manner.

Emilie Laffray

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 195 bytes
Desc: OpenPGP digital signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090929/e4c3688a/attachment.pgp>