I have two layers, one with lines, one with polygons. I want to delete lines that fully fall (contain) within the polygons. It seems really simple, but I can't figure this one out in either PostgreSQL/PostGIS or QGIS.
For the SQL I am trying:
delete from lines_test2
where ( select a.geom, b.geom
from lines_test2 a, straten b
where st_intersects(a.geom, b.geom));
But it gives me the error: 'subquery must return only one column'. Clipping in QGIS isn't a viable option either, because it should only delete full lines not parts of them.