Skip to main content
This function transforms a LineString containing multiple coordinates into an array of LineStrings, each with precisely two coordinates. The lenient argument, true by default, prevents an exception from being raised if the input geometry is not a LineString. ST_LineSegments

​
Signatures

ST_LineSegments(geom: Geometry, lenient: Boolean)

ST_LineSegments(geom: Geometry)

​
Parameters

​
geom
Geometry
required
The input geometry.
​
lenient
Boolean
The lenient value.

​
Return type

The resulting geometry.

​
Examples

SELECT ST_LineSegments(
        ST_GeomFromWKT('LINESTRING(0 0, 10 10, 20 20, 30 30, 40 40, 50 50)'),
       false
    )

[LINESTRING (0 0, 10 10), LINESTRING (10 10, 20 20), LINESTRING (20 20, 30 30), LINESTRING (30 30, 40 40), LINESTRING (40 40, 50 50)]

SELECT ST_LineSegments(
        ST_GeomFromWKT('POLYGON((0 0, 10 0, 10 10, 0 10, 0 0))')
    )

[]