Postgres support (operators)

[nene]

Operators

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