Navigation :

ST_LineFromMultiPoint

ST_LineFromMultiPoint
Prev   8.4. Geometry Constructors   Next

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

Prev   Up   Next
ST_LineFromEncodedPolyline  Home  ST_LineFromText