Predicates

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