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

[Arnaud Lesauvage]

Arnaud Lesauvage wrote:
> Is there a simple way to get the largest polygon (largest area) of 
> a multipolygon geometry, just with an SQL query ?
> 
> If not, I can write a simple perl function to do that, but if this 
> function already existed that would be better.

Don't bother, I wrote a simple plpgsql function finally.

--
Arnaud