ST_GeometryN method

Returns the nth geometry in the geometry collection.

By default, ST_GeometryN uses the original format for a geometry, if it is available. Otherwise, the internal format is used. For more information about internal and original formats, see STORAGE FORMAT clause, CREATE SPATIAL REFERENCE SYSTEM statement.

geomcollection-expression.ST_GeometryN(n)

Name	Type	Description
n	INT	The position of the element to return, from 1 to geomcollection-expression.ST_NumGeometries().

ST_Geometry Returns the nth geometry in the geometry collection.
The spatial reference system identifier of the result is the same as the spatial reference system of the geomcollection-expression.

Discuss this page in DocCommentXchange.