Was this helpful?
InteriorRingN
INTERIORRINGN(p Polygon, n integer)
Alias: ST_INTERIORRINGN
Returns the linestring for the nth interior ring of p. Interior rings are holes in the polygon.
Result type: linestring
Example:
SELECT ASTEXT(INTERIORRINGN(POLYFROMTEXT('POLYGON((2 0, 2 10, 0 10, 10 15, 20 10, 18 10, 18 0, 2 0), (13 0, 13 5, 17 5, 17 0, 13 0), (5 7, 5 10, 8 10, 8 7, 5 7))'),1));
--------------------------------
col1
--------------------------------
LINESTRING (13 0, 13 5, 17 5, 17 0, 13 0)
--------------------------------
Last modified date: 08/28/2024