[postgis-users] Dissolve on Polygons

[Nicolas Ribot]

> Hi list,
>
> can I perform a dissolve statement on a column to aggregate the geometries
> of features with the same attribute?
>
> cheers,
> Christian
>

Hi Christian,

Sure, a geomunion(the_geom) with a GROUP BY my_attrib clause:

select geomunion(the_geom) from my_table group by my_attrib;

Nicolas