[postgis-users] Removing holes from polygons

[Akhil Jaggarwal]

Thanks Paragon Corp and strk.

I've tried both the queries but I'm getting back the same multipolygon
which I had to explode to do subsetting.

The exploded table had 416 geometries (holes + polygons) as compared
to the original table with multipolygons which has 234 geometries.

I've also tried union to get the bigger of the contained geometries
but that doesn't seem to work either.


Regards
AKhil