Name

ST_InterpolatePoint — Return the value of the measure dimension of a geometry at the point closed to the provided point.

Synopsis

float ST_InterpolatePoint(geometry line, geometry point);

Description

Return the value of the measure dimension of a geometry at the point closed to the provided point.

Availability: 2.0.0

This function supports 3d and will not drop the z-index.

Examples

SELECT ST_InterpolatePoint('LINESTRING M (0 0 0, 10 0 20)', 'POINT(5 5)');
 st_interpolatepoint 
 ---------------------
			            10
	

See Also

ST_AddMeasure, ST_LocateAlong, ST_LocateBetween