ST_IsCollection
ST_IsCollection returns true if the input geometry is one of the following subtypes: GEOMETRYCOLLECTION, MULTIPOINT, MULTILINESTRING, or MULTIPOLYGON.
Syntax
ST_IsCollection(geom)
Arguments
- geom
-
A value of data type
GEOMETRYor an expression that evaluates to aGEOMETRYtype.
Return type
BOOLEAN
If geom is null, then null is returned.
Examples
The following SQL checks if the polygon is a collection.
SELECT ST_IsCollection(ST_GeomFromText('POLYGON((0 2,1 1,0 -1,0 2))'));
st_iscollection
-----------
false
