[postgis-users] Delete lines with other lines

[Nicolas Ribot]

> Hi
>
> I'm looking for a way to deletes lines (table_A) with others lines
> (table_B).
>
> I attach an image.
>
> I'm near the final result with the following query but "more than one row
> returned by a subquery...")
>
> delete from table_A a WHERE o.the_geom IN
>             (select st_linemerge (ST_Difference(a.the_geom, b.the_geom))
>                     FROM  table_B b,   (SELECT distinct (st_union
> (ST_Intersection(b.the_geom, a.the_geom))) as the_geom
>                                                   FROM table_A a, table_B b
>                                                   WHERE
> (ST_Intersects(a.the_geom, b.the_geom) ) ) b);
>

Hi,

Could you explain a bit further what you are trying to do ?
I can't really understand from the images what operation is involved
to delete lines from one table ?

Nicolas