LNNVL

Syntax

LNNVL
(
  value  IN boolean
)
RETURNS boolean;

Overview

The lnnvl function returns the opposite value for the given boolean value, i.e., false if the argument is true and true if it is false. Also returns true if the argument is NULL.

Parameters

Parameter	Description
value	boolean type: the boolean value to compare. If NULL, the result is true

Example

# test 1
SELECT oracle.LNNVL(true);  

 lnnvl 
-------
 f
(1 row)

# test 2
SELECT oracle.LNNVL(false);  

 lnnvl 
-------
 t
(1 row)

# test 3
SELECT oracle.LNNVL(NULL);  

 lnnvl 
-------
 t
(1 row)