ExteriorRing
EXTERIORRING(p Polygon)
Alias: ST_EXTERIORRING
Returns the linestring for the exterior ring of p. The exterior ring is the outside of the polygon.
Result type: linestring
Example:
SELECT ASTEXT(EXTERIORRING(POLYFROMTEXT('POLYGON((0 0, 0 10, 10 10, 10 0, 0 0), (2 2, 2 8, 8 8, 8 2, 2 2))')));
---------------------------------
col1
---------------------------------
LINESTRING (0 0, 0 10, 10 10, 10 0, 0 0)
---------------------------------
Last modified date: 08/28/2024