AND
Description
<left logical expression> AND <right logical expression>
evaluates to true, when the left and the right hand side logical expressions are 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 AND logical expression
NULL handling
PQL implements a three-valued logic system with the following truth table:
a | b | a AND b |
---|---|---|
true | true | true |
true | false | false |
true | NULL | NULL |
false | false | false |
false | NULL | false |
NULL | NULL | NULL |
Examples
[1] | ||||||||||||
| ||||||||||||
|
[2] | ||||||||||||||||
| ||||||||||||||||
|
[3] | |||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||
|