Skip to main content
Return a linestring being a substring of the input one starting and ending at the given fractions of total 2d length. Second and third arguments are Double values between 0 and 1. This only works with LINESTRINGs. ST_LineSubstring

​
Signatures

ST_LineSubstring (geom: Geometry, startfraction: Double, endfraction: Double)

​
Parameters

​
geom
Geometry
required
The input geometry.
​
startfraction
Double
required
The startfraction value.
​
endfraction
Double
required
The endfraction value.

​
Return type

The resulting geometry.

​
Example

SELECT ST_LineSubstring(ST_GeomFromWKT('LINESTRING(25 50, 100 125, 150 190)'), 0.333, 0.666)

LINESTRING (69.28469348539744 94.28469348539744, 100 125, 111.70035626068274 140.21046313888758)