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
    -- Negate false
    f1 := NOT(FALSE),
    -- Negate true
    f2 := NOT(TRUE),
    -- NULL operand
    f3 := NOT(NULL::BOOLEAN)
;