I have a postgis table full of very small line segments. I would like to merge them according to an attribute in another field.
update line_table set the_geom = ST_LineMerge(the_geom);
but how do I do this according to the attribute so that all the small segments with name="west" are joined, and those with name="north" are all joined etc?
Thanks for any help,