<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<META content="MSHTML 6.00.6000.16890" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=932051620-31082009><FONT face=Arial size=2>PostGIS
users,</FONT></SPAN></DIV>
<DIV><SPAN class=932051620-31082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=932051620-31082009><FONT face=Arial size=2>I was researching
how to effectively merge river segments in a really huge river dataset that
have the same name and touch each other (share a coordinate). The resulting
layers should be used for labeling purposes. I found that I could use something
along the lines of ST_LineMerge(ST_Collect(the_geom)) but would anybody have an
example how a merge operation would look to merge by river name and only if the
segments touch ?</FONT></SPAN></DIV>
<DIV><SPAN class=932051620-31082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=932051620-31082009><FONT face=Arial
size=2>Cheers</FONT></SPAN></DIV>
<DIV><SPAN class=932051620-31082009><FONT face=Arial
size=2>Karsten</FONT></SPAN></DIV></BODY></HTML>