ST_IsCollection

Introduction: Returns TRUE if the geometry type of the input is a geometry collection type. Collection types are the following:

• GEOMETRYCOLLECTION
• MULTI{POINT, POLYGON, LINESTRING}

Format: ST_IsCollection(geom: Geometry)

Return type: Boolean

Since: v1.5.0

Example:

SELECT ST_IsCollection(ST_GeomFromText('MULTIPOINT(0 0), (6 6)'))

Output:

true

Example:

SELECT ST_IsCollection(ST_GeomFromText('POINT(5 5)'))

Output:

false