[postgis-users] Removing holes from polygons

[strk]

On Tue, Nov 03, 2009 at 02:23:28PM -0500, Akhil Jaggarwal wrote:

> Any tips or hints on a query which removes all the inner holes from a
> polygon and returns and keeps the geometry of the largest one intact?

SELECT ST_ExteriorRing(geometry)  ...

--strk; 

 Free GIS & Flash consultant/developer      ()  ASCII Ribbon Campaign
 http://foo.keybit.net/~strk/services.html  /\  Keep it simple!