Hi,

I'm looking for a way to merge two overlapping polygons with a sql statement. I've been searching/trying things for a while and still no results.

 So far, I'm able to merge all polygons in one using :

SELECT GeomUnion(geom) FROM (SELECT (dump(the_geom)).geom FROM mytable) AS s;

but if I have a third polygon not overlapping the other two, it returns a single multipolygon with all three together.

 Any hint ?

--
Alexandre Dubé
Mapgears
www.mapgears.com

_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to