Function is_empty

The function checks a string variable for being either, NULL or ‘’ and is returing a boolean result.

Examples

SELECT is_empty('abc') AS res;
-- Result is false

Result:

res
f

SELECT is_empty('') AS res;
-- Result is true

Result:

res
t

SELECT is_empty(NULL) AS res;
-- Result is true

Result:

res
t