Skip to main content
Return the Nth point in a single linestring or circular linestring in the geometry. Negative values are counted backwards from the end of the LineString, so that -1 is the last point. Returns NULL if there is no linestring in the geometry. ST_PointN

​
Signatures

ST_PointN(geom: Geometry, n: Integer)

​
Parameters

​
geom
Geometry
required
The input geometry.
​
n
Integer
required
The index or count value.

​
Return type

The resulting geometry.

​
Example

SELECT ST_PointN(ST_GeomFromText('LINESTRING(0 0, 1 2, 2 4, 3 6)'), 2)

POINT (1 2)