Was this helpful?
NumInteriorRing
NUMINTERIORRING(p Polygon)
Alias: ST_NUMINTERIORRING
Returns the number of interior rings in p. Interior rings are holes in the polygon.
Result type: integer
Example:
SELECT NUMINTERIORRING(POLYFROMTEXT('POLYGON((0 0, 0 10, 10 10, 10 0, 0 0), (2 2, 2 4, 8 4, 8 2, 2 2), (2 6, 2 8, 8 8, 8 6, 2 6))'));
-------------
col1
-------------
2
-------------
Last modified date: 01/30/2023