As others have mentioned somewhere, you could also use: select st_buffer(st_collect(the_geom),0) from yourpolytable Eric
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of danny Sent: Friday, August 01, 2008 6:12 AM To: [email protected] Subject: [postgis-users] Merge all polygons from a dataset Hello everybody, I've converted a shapefile of Europe to PostGIS. I would like to merge all the countries together so that I only have one polygon left, the whole contour of Europe. I have tried ST_Union that gives me no result. I've tried several other functions to no avail. Does anybody know how I should proceed? Many thanks, Erik
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
