Product Documentation

Appearance

All platforms

ST_STARTPOINT ​

Returns the first point of a LINESTRING.

See also:

Syntax ​

sql
ST_STARTPOINT(<input>)

Arguments ​

  • <input>: The LINESTRING object

Returns ​

Returns a POINT representing the first point of the input LINESTRING. Returns NULL if input is not of LINESTRING type.

Example ​

sql
SELECT ST_AsText(ST_StartPoint('LINESTRING(1 1, 2 2, 3 3)'::GEOGRAPHY));
-- POINT(1 1)