Boolean Type and Logical Operators

operator

bool OR bool

bool OR bool -> bool

Logical disjunction.

Copy

db>

SELECT false OR true;

{true}

operator

bool AND bool

bool AND bool -> bool

Logical conjunction.

Copy

db>

SELECT false AND true;

{false}

operator

NOT bool

NOT bool -> bool

Logical negation.

Copy

db>

SELECT NOT false;

{true}

The AND and OR operators are commutative.

The truth tables are as follows:

a	b	a AND b	a OR b	NOT a
true	true	true	true	false
true	false	false	true	false
false	true	false	true	true
false	false	false	false	true

Product

Resources

Company

Newsletter

Subscribe to our mailing list to be the first to know about new blog posts and announcements.