[postgis-users] Transforming Linestring to Multipoint

[strk]

On Sun, Sep 27, 2009 at 10:47:40PM +0200, Mehmet Sirin wrote:

> so:  transforming LINESTRING ( x1 y1, x2 y2, x3 y4 ) to LINESTRING ( x1 y1,
> x2 y2, x3 y4, x4 y4, x5 y5, ... ) but it is the same line!
> Why doing all this stuff? I just want to find out the center of that
> linestring^^

How about this: 

 SELECT ST_Line_Interpolate_Point(line, 0.5);

http://postgis.refractions.net/documentation/manual-svn/ST_Line_Interpolate_Point.html

--strk;


-- 

 Free GIS & Flash consultant/developer      ()  ASCII Ribbon Campaign
 http://foo.keybit.net/~strk/services.html  /\  Keep it simple!