Boolean Type and Logical Operators

bool OR bool

Logical disjunction.

bool AND bool

Logical conjunction.

NOT bool

Logical negation.

bool = bool, bool < bool, …

Comparison 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

Light
Dark
System