ST_InteriorRingN(INT) method

Returns the nth interior ring in the curve polygon.

Syntax

curvepolygon-expression.ST_InteriorRingN(INT n)

n – The position of the element to return, from 1 to curvepolygon-expression.ST_NumInteriorRing().

ST_Curve Returns the nth interior ring in the curve polygon.

Example 1 – The following example returns the result LineString (3 1, 4 2, 5 1, 3 1).

SELECT NEW ST_CurvePolygon('CurvePolygon ( CircularString (2 0, 5 3, 2 0), (3 1, 4 2, 5 1, 3 1) )')
.ST_InteriorRingN( 1 )

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