Name

ST_LineFromMultiPoint — Creates a LineString from a MultiPoint geometry.

Synopsis

geometry ST_LineFromMultiPoint(geometry aMultiPoint);

Description

Creates a LineString from a MultiPoint geometry.

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

Examples

--Create a 3d line string from a 3d multipoint
SELECT ST_AsEWKT(ST_LineFromMultiPoint(ST_GeomFromEWKT('MULTIPOINT(1 2 3, 4 5 6, 7 8 9)')));
--result--
LINESTRING(1 2 3,4 5 6,7 8 9)
		

See Also

ST_AsEWKT, ST_Collect,ST_MakeLine