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

[Arnaud Lesauvage]

Ing. Carlos Eucario wrote:
> Yes,
> 
> select the_geom
> from mgm2000
> where area(the_geom) in
> (
>  select max(area(the_geom))
>  from mgm2000
> )
> 
> where mgm2000 is a polygon table..., and the_geom is the geometry column

That is not what I was trying to do Carlos, reread my post.

Regards
--
Arnaud