OR
Description
<left logical expression> OR <right logical expression>
evaluates to true, when either the left or the right hand side logical expression is true. Evaluates to false otherwise.
Parentheses may be used to simply make the complete logical expression more readable, but can also be used to change the meaning of the complete logical expression. This is possible through the order of precedence for logical expressions, described in the Functions and Operators section.
Syntax
logical expression OR logical expression
NULL handling
PQL implements a three-valued logic system with the following truth table:
a | b | a OR b |
---|---|---|
true | true | true |
true | false | true |
true | NULL | true |
false | false | false |
false | NULL | NULL |
NULL | NULL | NULL |
Examples
[1] | ||||||||||||
| ||||||||||||
|
[2] | ||||||||||||||||||
| ||||||||||||||||||
|
[3] | |||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||
|