ST_StartPoint

Returns first point of given linestring.

Signatures

ST_StartPoint(geom: Geometry)

geom

Geometry

required

The input geometry.

The resulting geometry.

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

POINT(100 150)

⌘I