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 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
