5. Geospatial Functions : StartPoint
 
Share this page                  
StartPoint
STARTPOINT(l Linestring)
Alias: ST_STARTPOINT
Returns the first point in l.
Result type: point
Example:
SELECT ASTEXT(STARTPOINT(LINEFROMTEXT('LINESTRING(0 0, 10 0, 10 10, 0 10)')));
--------------------------------
col1
--------------------------------
POINT (0 0)
--------------------------------