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! _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users