ST_PointN
Determines the Nth point from the linestring.
Syntax
ST_PointN(lgeo, n);- lgeo
- The input linestring geometry.
Type: VARCHAR(ANY)
- n
- The index, starting with 1, that identifies a point in the input linestring geometry.
Type: INT
Returns
A value of type VARCHAR(100) that contains the specified point geometry.
Examples
SELECT inza..ST_AsText(inza..ST_POINTN(inza..ST_WKTToSQL('LINESTRING (0 0, 1 1, 2 2, 9 9)'), 2));
ST_ASTEXT
-----------
POINT (1 1)
(1 row)