[postgis-users] is it possible to dissolve boundaries in postgis?

[strk at refractions.net]

On Thu, May 04, 2006 at 02:09:05PM -0500, Nelson Guda wrote:
> Hi all,
> 
> Is there a way to dissolve boundaries between adjacent polygons based  
> on attributes?  for example, if you have a database of polygons that  
> represent all of the counties in the US, a dissolve based on the name  
> of the state would result in polygons of all the states.  This is  
> possible in ArcGIS, but I haven't figured out a way to do it in postgis.

select state_name, geomunion(the_geom) as the_geom 
	from mytable group by state_name;

--strk;