Operators

Comparison and logic#

= != <> < <= > >=, AND OR NOT (implemented as is-true checks — NULL AND TRUE → false here, differing from strict 3VL; see NULL semantics), quantified op ANY|ALL|SOME.

Arithmetic and string#

+ - * / %, ^ (power, right-assoc), unary -x, || concat, & | # << >> bitwise. Temporal overloads: date ± int → date, ts ± interval → ts, date − date → int, ts − ts → interval (compare.rs:arithmetic_expression).

Pattern#

LIKE [ESCAPE], ILIKE (case flag ignored single-table path), SIMILAR TO, ~ ~* !~ !~* (→ regex_match* functions).

JSON (at multiplicative level)#

NULL rules#

Any comparison/arithmetic/BETWEEN/LIKE with NULL → NULL; WHERE keeps only true. IS NULL, IS DISTINCT FROM are NULL-aware. Most scalar functions return NULL on NULL input (concat skips NULLs, concat_ws NULL sep → NULL).