ST_NumCurves() method

Returns the number of curves defining the compound curve.

Syntax

compoundcurve-expression.ST_NumCurves()

INT Returns the number of curves contained in this compound curve.

Example 1 – The following example returns the result 2.

SELECT TREAT( Shape AS ST_CompoundCurve ).ST_NumCurves()
FROM SpatialShapes WHERE ShapeID = 17

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