ST_IsEmpty

Signature

BOOLEAN ST_IsEmpty(GEOMETRY geom);

Description

Returns TRUE if geom is empty.

Note

Implements the OpenGIS Simple Features Implementation Specification for SQL version 1.2.1

Examples

SELECT ST_IsEmpty('MULTIPOINT((4 4), (1 1), (1 0), (0 3)))');
-- Answer: FALSE
SELECT ST_IsEmpty('GEOMETRYCOLLECTION(
                     MULTIPOINT((4 4), (1 1), (1 0), (0 3)),
                     LINESTRING(2 6, 6 2),
                     POLYGON((1 2, 4 2, 4 6, 1 6, 1 2)))');
-- Answer: FALSE
SELECT ST_IsEmpty('POLYGON EMPTY');
-- Answer: TRUE

See also