[postgis-users] Select largest polygon of a multipolygon ?

[strk at refractions.net]

On Tue, Jul 11, 2006 at 07:29:44PM +0200, Arnaud Lesauvage wrote:
> Nahum Castro a écrit :
> >select the area, order by area desc and limit to 1
> 
> You did not understand the question nore did you read previous 
> answers.
> "Is there a simple way to get the largest polygon of a 
> multipolygon geometry ?"
> I can't find another way to explain that, but it seems that my 
> question is not clear.

See dump() and the two previous posts.
(yes, I understood you made it, but might be useful for others)

--strk;