ST_IsEmpty

ST_IsEmpty returns true if the input geometry is empty. A geometry is not empty if it contains at least one nonempty point.

ST_IsEmpty returns true if the input geometry has at least one nonempty point.

Syntax

ST_IsEmpty(geom)

Arguments

geom

A value of data type GEOMETRY or an expression that evaluates to a GEOMETRY type.

Return type

BOOLEAN

If geom is null, then null is returned.

Examples

The following SQL checks if the specified polygon is empty.

SELECT ST_IsEmpty(ST_GeomFromText('POLYGON((0 2,1 1,0 -1,0 2))'));

st_isempty
-----------
 false