Product Documentation

Appearance

All platforms

ST_ISEMPTY ​

Returns TRUE if the GEOGRAPHY represents an empty geometry collection, polygon, point etc.

Syntax ​

sql
ST_ISEMPTY(<input>)

Arguments ​

  • <input>: A GEOGRAPHY object

Returns ​

Returns a BOOLEAN:

  • TRUE if the GEOGRAPHY is empty
  • FALSE otherwise

Example ​

sql
SELECT ST_ISEMPTY('POLYGON EMPTY'::GEOGRAPHY);
-- TRUE

SELECT ST_ISEMPTY('POINT(1 1)'::GEOGRAPHY);
-- FALSE