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