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_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
