ST_NumGeometries()¶

TL;DR¶

Use ST_NumGeometries() to count a collection’s members.

Returns the number of geometries in a collection.

Syntax¶

ST_NumGeometries(geom)

Arguments¶

Argument	Description
`geom`	A `GEOMETRY` or `GEOMETRY32` value.

Return Value¶

Returns INT64.

Usage Notes¶

The function accepts GEOMETRY32, as covered by geo_review_fixes.sql.

Examples¶

DROP DATABASE IF EXISTS geo_numgeometries_demo;
CREATE DATABASE geo_numgeometries_demo;
USE geo_numgeometries_demo;

SELECT ST_NumGeometries(ST_GeomFromText('MULTIPOINT(1 1,2 2,3 3)')) AS member_count;

DROP DATABASE geo_numgeometries_demo;

See Also¶