[postgis-users] More than one row returned...

Martin Fafard martin.fafard at geoprojection.com
Tue Jan 31 10:34:34 PST 2012


Hi

I have this query

delete FROM original o
WHERE st_intersects (o.the_geom,  (select (st_intersection (c.the_geom, 
o.the_geom))
  from original o, cutter c
  group by c.the_geom, o.the_geom));


to delete portions of lines in a table that intersect with other lines 
in another table.
Error: the subquery return "more than one row...". Don't know why!

Thanks

MartinF



More information about the postgis-users mailing list