ST_GeometryN()¶

TL;DR¶

Use ST_GeometryN() to retrieve a one-based member from a collection.

Returns the n-th geometry member of a collection.

Syntax¶

ST_GeometryN(geom, n)

Arguments¶

Argument	Description
`geom`	A `GEOMETRY` or `GEOMETRY32` collection value.
`n`	The one-based member position, as `INT64`.

Return Value¶

Returns the same geometry family as the input, preserving SRID metadata.

Usage Notes¶

Examples¶

DROP DATABASE IF EXISTS geo_geometryn_demo;
CREATE DATABASE geo_geometryn_demo;
USE geo_geometryn_demo;

SELECT ST_AsText(ST_GeometryN(ST_GeomFromText('MULTIPOINT(1 1,2 2,3 3)'), 2)) AS member;

DROP DATABASE geo_geometryn_demo;

See Also¶