ST_NumPoints() method

Returns the number of points defining the linestring.

Syntax

linestring-expression.ST_NumPoints()

INT Returns NULL if the linestring value is empty, otherwise the number of points in the value.

Example 1 – The following example returns the result 3.

SELECT TREAT( Shape AS ST_LineString ).ST_NumPoints()
FROM SpatialShapes WHERE ShapeID = 5

SQL/MM (ISO/IEC 13249-3: 2006) 7.2.4