Name

ST_IsEmpty — Tests if a Geometry corresponds to the empty set.

Synopsis

boolean ST_IsEmpty(bytea Geometry);

Alias

IsEmpty

Description

Tests if a Geometry corresponds to the empty set. Returns False if the incoming geometry it is not an empty geometry

According to Spatial Standards this mehod should return 1 for an empty geometry. Though, JASPA returns NULL because converts to null every empty geometry. See XXXXXXXXX for further information.

Coordinate Dimensions
2D3DM
Spatial Standards Support
OGC SFS for SQL. 1.1 (1999)OGC SFS for SQL. 1.1.0 (2005)OGC SFS for SQL. 1.2.0 (2006)SQL-MM Part 3
2.1.1.17.2.10.17.2.8.25.1.7

Examples

SELECT ST_IsEmpty(ST_GeomFromText('POINT (0 0)'));
--Result
FALSE

SELECT ST_IsEmpty(ST_GeomFromText('POINT EMPTY'));
--Result
true

Related functions