Predicates are expressions which return a Boolean value as a result, that is, FALSE, TRUE, or NULL (or its alias, UNKNOWN).
Predicates can be used as follows:
- In the SELECT list as well as in the WHERE and HAVING clause of a SELECT query
- In the WHERE clause of the UPDATE and DELETE statements
- In the ON clause and the WHERE clauses of the MERGE statement
The supported predicates in Exasol include