ST_IsCollection

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

Signatures

ST_IsCollection(geom: Geometry)

geom

Geometry

required

The input geometry.

Returns true or false.

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

true

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

false

⌘I