Was this helpful?
PointN
POINTN(l Linestring, n integer)
Alias: ST_POINTN
Returns the nth point from l. 1 is considered the first point (rather than 0).
Result type: point
Example:
SELECT ASTEXT(POINTN(LINEFROMTEXT('LINESTRING(0 0, 10 0, 10 10, 0 10)'), 3));
--------------------------------
col1
--------------------------------
POINT (10 10)
--------------------------------
Last modified date: 11/28/2023