ST_InteriorRingN(INT) method

Returns the nth interior ring in the polygon.

Syntax

polygon-expression.ST_InteriorRingN(INT n)

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

ST_LineString Returns the nth interior ring in the polygon.

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

SELECT NEW ST_Polygon('Polygon ((0 0, 10 0, 5 10, 0 0), (3 3, 3 5, 7 5, 7 3, 3 3))')
.ST_InteriorRingN( 1 )

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