Amazon Redshift will no longer support the use of Python UDFs after June 30, 2026. We will start enforcing it in phases. For more information on the details of Python end of life and migration options, see the blog post that was published on June 30, 2025.

ST_NumGeometries

ST_NumGeometries returns the number of geometries in an input geometry.

Syntax

ST_NumGeometries(geom)

Arguments

Return type

INTEGER representing the number of geometries in geom.

If geom is null, then null is returned.

If geom is a single empty geometry, then 0 is returned.

If geom is a single nonempty geometry, then 1 is returned.

If geom is a GEOMETRYCOLLECTION or a MULTI subtype, then the number of geometries is returned.

Examples

The following SQL returns the number of geometries in the input multilinestring.

SELECT ST_NumGeometries(ST_GeomFromText('MULTILINESTRING((0 0,1 0,0 5),(3 4,13 26))'));

st_numgeometries
-------------
 2