NexusDB V3 Manual

Predicates

Specify a condition that evaluates to a boolean value.

Syntax

<predicate> ::=

<search condition> ::= <boolean value expression>

Usage

Predicates are boolean value expressions, and can be used in SQL everywhere a boolean value is permitted.

Search conditions

The main function of the predicates is to specify a search condition that is used in data statements to join tables and filter out unwanted rows from a set, and elsewhere in SQL a conditional computation is specified. The search condition can be a single predicate or multiple predicates combined with the AND and OR boolean operators.

Conformance