<div dir="ltr">Check out ST_Merge()<br><br><div class="gmail_quote">On Tue, Oct 7, 2008 at 3:54 PM, Stephen Woodbridge <span dir="ltr"><<a href="mailto:woodbri@swoodbridge.com">woodbri@swoodbridge.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hi all,<br>
<br>
This is very annoying. I have two linestrings the join end-to-end and I want to build a new single linestring by merging the two. How can I do this?<br>
<br>
Thanks,<br>
  -Steve<br>
<br>
<br>
select astext( ST_Union(         ST_GeomFromText('LINESTRING(35.5269251710001 33.891749555,35.527091166 33.8917984710001)'),<br>
ST_GeomFromText('LINESTRING(35.527091166 33.8917984710001,35.5274352000001 33.8918998510001,35.528236559 33.8919810230001)')                                    ));<br>
<br>
              astext <br>
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>
 MULTILINESTRING((35.5269251710001 33.891749555,35.527091166 33.8917984710001),(35.527091166 33.8917984710001,35.5274352000001 33.8918998510001,35.528236559 33.8919810230001))<br>
(1 row)<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>************************************<br>David William Bitner<br>
</div>