ST_InteriorRingN method

Returns the nth interior ring in the polygon.

Note

By default, ST_InteriorRingN uses the original format for a geometry, if it is available. Otherwise, the internal format is used. For more information about internal and original formats, see STORAGE FORMAT clause, CREATE SPATIAL REFERENCE SYSTEM statement.

Syntax

polygon-expression.ST_InteriorRingN(n)

Parameters

Name	Type	Description
n	INT	The position of the element to return, from 1 to polygon-expression.ST_NumInteriorRing().

Returns

ST_LineString Returns the nth interior ring in the polygon.
The spatial reference system identifier of the result is the same as the spatial reference system of the polygon-expression.

Standards and compatibility

Example

Discuss this page in DocCommentXchange.