ST_InteriorRingN

Returns the Nth interior linestring ring of the polygon geometry. Returns NULL if the geometry is not a polygon or the given N is out of range

Signatures

ST_InteriorRingN(geom: Geometry, n: Integer)

Parameters

geom

Geometry

required

The input geometry.

Integer

required

The index or count value.

Return type

The resulting geometry.

Example

SELECT ST_InteriorRingN(ST_GeomFromText('POLYGON((0 0, 0 5, 5 5, 5 0, 0 0), (1 1, 2 1, 2 2, 1 2, 1 1), (1 3, 2 3, 2 4, 1 4, 1 3), (3 3, 4 3, 4 4, 3 4, 3 3))'), 0)

LINESTRING (1 1, 2 1, 2 2, 1 2, 1 1)

ST_HasZ

ST_IsClosed

⌘I

Wherobots Cloud REST API

WherobotsDB

Vector tiles (PMTiles)

Havasu (Iceberg) table management

GeoStats and Map Matching

Rasterflow

Signatures

Parameters

Return type

Example

​Signatures

​Parameters

​Return type

​Example

Signatures

Parameters

Return type

Example