LNNVL
The LNNVL function determines whether one or both operands in a condition are NULL. This function can be used in a WHERE clause or as a WHEN condition in a CASE expression. With the condition as an argument, it returns TRUE if the condition is FALSE or UNKNOWN, or FALSE if the condition is TRUE.
LNNVL(condition)
Example:
select lnnvl(math = 100) from test;
LNNVL(MATH = 100)
-----------------------------------
t
t
f
t
(4 rows)
Top comments (0)