ST_StartPoint

Introduction: Returns first point of given linestring.

Format: ST_StartPoint(geom: Geometry)

Return type: Geometry

Since: v1.5.0

Example:

SELECT ST_StartPoint(ST_GeomFromText('LINESTRING(100 150,50 60, 70 80, 160 170)'))

Output:

POINT(100 150)