NOT()

All functions > LOGICAL > NOT()

Returns FALSE if the operand is TRUE, TRUE if it is FALSE.

Signatures

Returns: Negated truth value; NULL if the operand is NULL

NOT(expr1: BOOLEAN) → BOOLEAN

Notes

• Unary negation on a boolean expression

Related operators

• NOT

Examples

NOT(expr)

SELECT
    f1 := NOT(FALSE), -- Negate false
    f2 := NOT(TRUE), -- Negate true
    f3 := NOT(NULL::BOOLEAN) -- NULL operand
;