[postgis-users] Size of a multipolygon

[Stephen Woodbridge]

http://www.postgis.org/documentation/manual-1.5/ST_NumGeometries.html

On 5/1/2012 11:26 PM, Ben Madin wrote:
> Hello all,
>
> I'm sure the answer is simple, but I'm lost on what to search on - I
> need to quickly search through several thousand multi polygons for
> any which have more than one part making them up.
>
> What is the best way to do this…? (I've tried array_length(), but
> don't seem to be able to feed it the right part. I can't believe I
> can't find a function that does it… or am I looking at dumping the
> multi polygons into a new table and counting the number of lines for
> each one...
>
> cheers
>
> Ben
>
>
> _______________________________________________ postgis-users mailing
> list postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users