[postgis-users] appending to a LINESTRING

[Just van den Broecke]

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