<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
In which case why not just extend ST_StartPoint to include this
behaviour? Always nicer to keep the function list as short as
possible.<br>
<br>
<div class="moz-cite-prefix">On 9/27/2012 7:31 AM, David William
Bitner wrote:<br>
</div>
<blockquote
cite="mid:CAEqvsZsUbzmG__RxNBeA40Y49Qr9ph-ktgtdibiaJspdN6hELQ@mail.gmail.com"
type="cite">Perhaps to match a number of people's expectations,
there should be an ST_First Point() that is basically
ST_StartPoint(ST_GeometryN(ST_Multi(geometry),1))
<div><br>
</div>
<div><br>
<br>
<div class="gmail_quote">On Tue, Sep 25, 2012 at 4:08 PM, Paul
Ramsey <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:pramsey@opengeo.org" target="_blank">pramsey@opengeo.org</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">When
ST_NumGeometries == 1, you can run ST_StartPoint on<br>
ST_GeometryN(geom,1). Where ST_NumGeometries > 1 you are
in<br>
"interpretation land". What's the start point of a geometry
with two<br>
lines?<br>
<span class="HOEnZb"><font color="#888888"><br>
P.<br>
</font></span>
<div class="HOEnZb">
<div class="h5"><br>
On Tue, Sep 25, 2012 at 1:38 PM, David Quinn <<a
moz-do-not-send="true"
href="mailto:daithiquinn@gmail.com">daithiquinn@gmail.com</a>>
wrote:<br>
> As ST_StartPoint( multilinestring ) returns NULL
for PostGIS 2.0<br>
> (<a moz-do-not-send="true"
href="http://postgis.refractions.net/docs/ST_StartPoint.html"
target="_blank">http://postgis.refractions.net/docs/ST_StartPoint.html</a>
), what<br>
> approach can be used to identify the start and end
points of a<br>
> multilinestring?<br>
><br>
> Thanks,<br>
> David<br>
> _______________________________________________<br>
> postgis-users mailing list<br>
> <a moz-do-not-send="true"
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
> <a moz-do-not-send="true"
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
_______________________________________________<br>
postgis-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a moz-do-not-send="true"
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
</div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
************************************<br>
David William Bitner<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<p class="" avgcert""="" color="#000000" align="left">No virus
found in this message.<br>
Checked by AVG - <a moz-do-not-send="true"
href="http://www.avg.com">www.avg.com</a><br>
Version: 2012.0.2221 / Virus Database: 2441/5293 - Release Date:
09/26/12</p>
</blockquote>
<br>
</body>
</html>