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

Bruno Friedmann bruno at ioda-net.ch
Thu Mar 4 00:48:47 PST 2010


On 03/04/2010 09:15 AM, Olivier Courtin wrote:
> 
> 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
> 

Thank you Olivier, I've missed it !

Perhaps in documentation we need a cross link (see also) between st_setpoint (the setter) and st_pointn (the getter).


-- 

     Bruno Friedmann




More information about the postgis-users mailing list