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

[Nelson Guda]

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.

thanks,
nelson