Operators

Arithmetic, comparison, logical, pattern-matching, JSON, array, and bitwise operators with their precedence and semantics.

Arithmetic

• Addition
• Division
• Exponentiation
• Modulo
• Multiplication
• Subtraction

Array

• Array contained by
• Array contains
• Array overlap

Bitwise

• Bit shift left
• Bit shift right
• Bitwise AND
• Bitwise OR
• Bitwise XOR

Comparison

• Equal
• Greater than
• Greater than or equal
• Less than
• Less than or equal
• Not equal

JSON

• JSON field (as JSON)
• JSON field (as text)
• JSON path (as JSON)
• JSON path (as text)

Logical

• Logical AND
• Logical OR

Pattern Match

• Regex match (case insensitive)
• Regex match (case sensitive)
• Regex not match
• Regex not match (case insensitive)
• SQL regex match

String Op

• Concatenation

Unary

• Absolute value
• Bitwise NOT
• Cube root
• Factorial
• Logical NOT
• Negation
• Square root
• Unary plus