[postgis-users] Collection to MultiPolygon

[strk at refractions.net]

On Fri, Mar 18, 2005 at 09:49:22AM -0700, Ethan Alpert wrote:
> 
> 
> I'm still not seeing how you can create a multipolygon from a collection
> with dump() even after reading it.

something like:
	select collect(geom) from dump(geom) where geometrytype(geom) == 'POLYGON' 
... might need slithgly different syntaxes with different pgsql versions ..
--strk;


> 
> -e
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> strk at refractions.net
> Sent: Friday, March 18, 2005 7:24 AM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Collection to MultiPolygon
> 
> 
> On Fri, Mar 18, 2005 at 08:14:45AM -0600, Simpson wrote:
> > Greetings again,
> > 
> > I ran a polygonize on a feature and it faithfully returns a 
> > collection.
> > 
> > Is there any way to convert the collection to a multipolygon?
> > 
> > I tried every combination of functions that looked promising with no 
> > luck.
> 
> Did you try dump() ?
> Check manual page for it.
> --strk;
> 
> > 
> > Thanks for any help,
> > Drew.
> > 
> > _______________________________________________
> > postgis-users mailing list postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users