ST_NumPoints() method

Returns the number of points defining the circularstring.

Syntax

circularstring-expression.ST_NumPoints()

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

Example 1 – The following example returns the result 5.

SELECT TREAT( Shape AS ST_CircularString ).ST_NumPoints()
FROM SpatialShapes WHERE ShapeID = 18

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