5. Geospatial Functions : NumPoints
 
Share this page                  
NumPoints
NUMPOINTS(l Linestring)
Alias: ST_NUMPOINTS
Returns the number of points that make up l.
Result type: integer
Example: Query how many points are in a linestring:
SELECT NUMPOINTS(LINEFROMTEXT('LINESTRING(0 0, 5 5, 0 10, 5 15)'));
-------------
col1
-------------
4
-------------