[postgis-users] Looking for a equivalent of st_getpoint() to replace Z in a given point in a linestring

Olivier Courtin olivier.courtin at oslandia.com
Thu Mar 4 00:15:52 PST 2010


On Mar 4, 2010, at 9:12 AM, Bruno Friedmann wrote:

Bruno,

> We have the st_setpoint() and the st_numpoints that I can use to  
> loop for each point.
> but I've not found a st_getpoint(line_geom, index point) returning  
> the point geom.

PointN is your friend
http://postgis.refractions.net/documentation/manual-1.5/ST_PointN.html

Have a look to the example with generate_series loop construction

--
Olivier




More information about the postgis-users mailing list