AND
logical operator chains multiple criteria together. A valid operand of an AND
operator must be one of: TRUE
, FALSE
, and NULL
. The AND
operator has a higher precedence than the OR
operator. NULL
represents unknown. Therefore, if one operand is NULL
and the other operand is FALSE
the result is FALSE
, because one FALSE
operand is sufficient for a FALSE
result. If one operand is NULL
and the other operand is either TRUE
or NULL
, the result is NULL
(unknown).
The following table shows how the AND
operator is evaluated based on its two operands:
TRUE FALSE NULL TRUE TRUE FALSE NULL FALSE FALSE FALSE FALSE NULL NULL FALSE NULL
conditional_term ::= conditional_term AND conditional_factor
@see AndExpression @version 2.4 @since 2.4 @author Pascal Filion
|
|
|
|