5. Geospatial Functions : PointN
 
Share this page                  
PointN
POINTN(l Linestring, n integer)
Alias: ST_POINTN
Returns the nth point from l. 1 is considered the first point (rather than 0).
Result type: point
Example:
SELECT ASTEXT(POINTN(LINEFROMTEXT('LINESTRING(0 0, 10 0, 10 10, 0 10)'), 3));
--------------------------------
col1
--------------------------------
POINT (10 10)
--------------------------------