Name
ST_EndPoint — Returns the last point of a LINESTRING
geometry as a POINT.
Synopsis
boolean ST_EndPoint(geometry g);
Description
Returns the last point of a LINESTRING geometry
as a POINT or NULL if the input
parameter is not a LINESTRING.
This method implements the SQL/MM specification:
SQL-MM 3: 7.1.4
This function supports 3d and will not drop the z-index.
Examples
postgis=# SELECT ST_AsText(ST_EndPoint('LINESTRING(1 1, 2 2, 3 3)'::geometry));
st_astext
------------
POINT(3 3)
(1 row)
postgis=# SELECT ST_EndPoint('POINT(1 1)'::geometry) IS NULL AS is_null;
is_null
----------
t
(1 row)
--3d endpoint
SELECT ST_AsEWKT(ST_EndPoint('LINESTRING(1 1 2, 1 2 3, 0 0 5)'));
st_asewkt
--------------
POINT(0 0 5)
(1 row)