[postgis-users] appending to a LINESTRING

[David William Bitner]

Update g_track set line=AddPoint(line, GeomFromText('POINT(4.92 52.35)',4326))
where id=101;

On 2/12/07, Just van den Broecke <just at justobjects.nl> wrote:
>
> Hi,
>
> What is the way to go for appending POINTs to a LINESTRING without
> reading the entire LINESTRING into the client ? i.e. for example
>
> SELECT AddPoint(line, GeomFromText('POINT(4.92 52.35)',4326)) as line
> FROM ( SELECT line FROM g_track WHERE id=101) foo;
>
> Will do the append but will still require an UPDATE to be done with the
> resulting line. Would "one-shot" appending require a (plpg)sql function
> or is there some other way ?
>
> thanks,
>
> --Just
>
> Just van den Broecke
> http://www.justobjects.nl
> The Netherlands
>
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
************************************
David William Bitner
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070212/7a457fff/attachment.html>