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