Skip to main content
Return the 0-based Nth geometry if the geometry is a GEOMETRYCOLLECTION, (MULTI)POINT, (MULTI)LINESTRING, MULTICURVE or (MULTI)POLYGON. Otherwise, return null ST_GeometryN

Signatures

Parameters

geom
Geometry
required
The input geometry.
n
Integer
required
The index or count value.

Return type

The resulting geometry.

Example