Operators

Jump to bottom Edit New page

Rene Saarsoo edited this page Aug 9, 2022 · 42 revisions

All dialects support the following standard operators:

Comparison: =, >, >=, <, <=, <>, !=
Boolean: AND, OR, NOT, IS, IS NOT
Math: +, -, *, /

Below only additional non-standard operators are listed.

SingleStoreDB:

Comparison operators: <=> (NULL-safe equal operator)
Bitwise operators: &, |, ^, ~, >>, <<
Boolean operators:¹ &&, ||

Notes:

Tested SingleStoreDB boolean operators manually. Found no docs for these.