ST_NumGeometries

Introduction: Returns the number of sub-geometries in a geography object. Returns 1 for single geometries (Point, LineString, Polygon).

Format:

ST_NumGeometries (A: Geography)

Return type: Integer

Since: v1.9.1

SQL Example

SELECT ST_NumGeometries(ST_GeogFromWKT('MULTIPOINT ((0 0), (1 1), (2 2))'));

Output:

3