ST_CurveN(INT) method

Syntax

compoundcurve-expression.ST_CurveN(INT n)

Parameters

• n – The position of the element to return, from 1 to compoundcurve-expression.ST_NumCurves().

Returns

ST_Curve Returns the nth curve in the compound curve.

Examples

• Example 1 – The following example returns the result CircularString (0 0, 1 1, 2 0).

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

Standards

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