Operators

The following operators are supported by Opteryx. Click a name for details.

binary

• Division /
• Subtraction -
• Modulo %
• Multiplication *
• Integer division DIV
• Addition +
• Concatenation ||

bitwise

• Bitwise AND &
• Bitwise OR |
• Bitwise XOR ^
• Left shift <<
• Right shift >>

comparison

• Array contains all @>>
• Array contains any @>
• JSON path exists @?
• Equals =
• Greater than >
• Greater than or equal >=
• Case-insensitive like ILIKE
• In list IN
• Like LIKE
• Less than <
• Less than or equal <=
• Not equals !=
• Not case-insensitive like NOT ILIKE
• Not in list NOT IN
• Not like NOT LIKE
• Not regex like NOT RLIKE
• Regex like RLIKE

extraction

• JSON extract ->
• JSON extract text ->>
• Subscript access []

logical

• Logical AND AND
• Logical OR OR
• Logical XOR XOR