ST_IsEmpty

Determine whether a geometry is empty, that is, whether it has no points.

Syntax

ST_IsEmpty(geo);
geo
The input geometry.

Type: ST_GEOMETRY(ANY)

Returns

A value of type BOOL that is TRUE if the geometry is empty; otherwise FALSE.

Examples

SELECT inza..ST_IsEmpty(inza..ST_WKTToSQL('POLYGON ((0 0, 11 0, 11 11, 0 11, 0 0))'));
 
ST_ISEMPTY
----------
f
(1 row)
SELECT inza..ST_IsEmpty(inza..ST_WKTToSQL('POLYGON EMPTY'));

ST_ISEMPTY
----------
t
(1 row)
SELECT inza..ST_IsEmpty(inza..ST_WKTToSQL('LINESTRING EMPTY'));

ST_ISEMPTY
----------
t
(1 row)