ST_StartPoint

Determine the first point of a linestring.

Syntax

ST_StartPoint(lgeo);

lgeo: The input linestring geometry.
Type: VARCHAR(ANY)

Returns

A value of type VARCHAR(50) that contains a point geometry that represents the first point of the linestring, or NULL if the linestring is empty, or if there is no first point.

Examples

SELECT inza..ST_AsText(inza..ST_StartPoint(inza..ST_WKTToSQL('LINESTRING (0 0, 11 0, 11 11)')));
 
ST_ASTEXT
-----------
POINT (0 0)
(1 row)

SELECT inza..ST_AsText(inza..ST_StartPoint(inza..ST_WKTToSQL('LINESTRING (0 0 1, 11 0 5, 11 11 7)')));

ST_ASTEXT
-----------
POINT Z (0 0 1)
(1 row)

SELECT inza..ST_StartPoint(inza..ST_WKTToSQL('LINESTRING EMPTY'));

ST_STARTPOINT
---------------
(1 row)