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

ST_GeometryN(geom: Geometry, n: Integer)

​
Parameters

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

​
Return type

The resulting geometry.

​
Example

SELECT ST_GeometryN(ST_GeomFromText('MULTIPOINT((1 2), (3 4), (5 6), (8 9))'), 1)

POINT (3 4)