NOT

All functions > LOGICAL > NOT

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

Syntax

NOT expr  ·  NOT(expr)

NOT expr  ·  NOT(expr)

Notes

• Applies to boolean expressions, including comparisons and other logical combinations
• NULL in, NULL out

Related Functions

• NOT()

Examples

NOT expr

SELECT
    -- Prefix negates false
    f1 := NOT FALSE,
    -- Prefix negates true
    f2 := NOT TRUE,
    -- NULL operand
    f3 := NOT NULL::BOOLEAN
;