Operators

• 100% correct operator precedence
• OPERATOR(...) syntax, like OPERATOR(+) or OPERATOR(schema.table.|//)
• ~ can be both a unary or binary operator (bitwise negation or string match)
• Array-access:
  • element access foo[1]
  • slice operator: foo[1:5], foo[2:], foo[:5], foo[:]
• Type casts
  • CAST(expr AS type)
  • expr::type
  • type(expr) e.g. float8(125)
  • type 'string' e.g. TIME (6) WITH TIME ZONE '15:30' or VARCHAR(100) 'Hello'
• Logical operators: OR, AND, NOT
• Comparison operators:
  • >, <, >=, <=, =, <>, !=
  • [NOT] BETWEEN ... AND ...
  • [NOT] BETWEEN SYMMETRIC ... AND ...
  • IS [NOT] DISTINCT FROM
  • IS [NOT] {NULL | TRUE | FALSE | UNKNOWN}
  • ISNULL
  • NOTNULL
  • row constructor comparison
• Math operators:
  • Unary +
  • Unary -
  • Unary ~
  • +, -, *, /
  • %
  • ^
  • Others: |/, ||/, @, &, |, >>, <<
  • # works as bitwise XOR, not as comment
• String operators:
  • ||
  • IS [NOT] [form] NORMALIZED
  • ^@
  • COLLATE
• Pattern matching:
  • [NOT] LIKE
  • [NOT] ILIKE
  • ESCAPE with LIKE & ILIKE
  • SIMILAR TO
  • ESCAPE with SIMILAR TO
  • Regex and like operators: ~, !~, ~*, !~*, ~~, !~~, ~~*, !~~*
• JSON and JSONB operators:
  • ->, ->>, #>, #>>
  • @>, <@, ?, ?|, ?&, ||, -, #-, @?, @@
• Subquery operators:
  • EXISTS
  • [NOT] IN
  • ANY, SOME, ALL
• Date manipulation:
  • EXTRACT(... FROM ...)
  • AT TIME ZONE
• Function calls:
  • Named function arguments.
  • Old := syntax for named function arguments.
  • parenthesis-less date-time functions
  • session information functions