ST_IsEmpty()¶

TL;DR¶

Use ST_IsEmpty() to test whether a geometry is empty.

Returns whether a geometry contains no elements.

Syntax¶

ST_IsEmpty(geom)

Arguments¶

Argument	Description
`geom`	A `GEOMETRY` or `GEOMETRY32` value.

Return Value¶

Returns BOOL.

Usage Notes¶

The GEOMETRY32 overload is covered by geo_review_fixes.sql.

Examples¶

DROP DATABASE IF EXISTS geo_isempty_demo;
CREATE DATABASE geo_isempty_demo;
USE geo_isempty_demo;

SELECT ST_IsEmpty(ST_GeomFromText('POINT EMPTY')) AS is_empty;

DROP DATABASE geo_isempty_demo;

See Also¶