From: Emilie Laffray <emilie.laffray@gmail.com>
Subject: [postgis-users] (no subject)
Date: Tue, 29 Sep 2009 19:36:25 +0100
Message-ID: <4AC253A9.60906@gmail.com> (raw)
In-Reply-To: <SNT113-W4279207C375549AD79B92EA0D50@phx.gbl>
References: <SNT113-W4279207C375549AD79B92EA0D50@phx.gbl>
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;
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: postgis-users@lists.osgeo.org
Cc: emilie.laffray@gmail.com
Subject: Re: [postgis-users] (no subject)
In-Reply-To: <4AC253A9.60906@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox