ST_NumGeometries() method

Returns the number of geometries contained in the geometry collection.

Syntax

geomcollection-expression.ST_NumGeometries()

INT Returns the number of geometries stored in this collection.

Example 1 – The following example returns the result 3.

SELECT NEW ST_MultiPoint('MultiPoint ((10 10), (12 12), (14 10))')
.ST_NumGeometries()

SQL/MM (ISO/IEC 13249-3: 2006) 9.1.4