OR

All functions > LOGICAL > OR

Returns TRUE when at least one boolean operand is TRUE.

Syntax

expr1 OR expr2  ·  OR(expr1, expr2)

expr1 OR expr2  ·  OR(expr1, expr2)

Notes

• Chains as nested binary OR: a OR b OR c groups as (a OR b) OR c
• AND binds tighter than OR
• Three-valued logic: TRUE with NULL yields TRUE; FALSE with NULL yields NULL; both NULL yields NULL

Related Functions

• OR()

Examples

expr1 OR expr2

SELECT
    -- Infix one true
    f1 := FALSE OR TRUE,
    -- Infix both false
    f2 := FALSE OR FALSE,
    -- Infix TRUE absorbs NULL
    f3 := TRUE OR NULL::BOOLEAN,
    -- Infix unknown with FALSE
    f4 := FALSE OR NULL::BOOLEAN
;