Postgres support (custom operators)

[nene]

Operator

• [ ] CREATE OPERATOR
  • [ ] op_name (allow valid operator characters)
  • [ ] schema.op_name
  • [ ] {FUNCTION | PROCEDURE} = func_name
  • [ ] LEFTARG = type
  • [ ] RIGHTARG = type
  • [ ] COMMUTATOR = op
  • [ ] NEGATOR = op
  • [ ] RESTRICT = func_name
  • [ ] JOIN = func_name
  • [ ] HASHES
  • [ ] MERGES
• [ ] ALTER OPERATOR
  • [ ] ( { left_type | NONE } , right_type )
  • [ ] OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
  • [ ] SET SCHEMA new_schema
  • [ ] SET ( ..., ...)
    • [ ] RESTRICT = { res_proc | NONE }
    • [ ] JOIN = { join_proc | NONE }
    • [ ] COMMUTATOR = op
    • [ ] NEGATOR = op
    • [ ] HASHES
    • [ ] MERGES
• [ ] DROP OPERATOR
  • [ ] IF EXISTS
  • [ ] ( { left_type | NONE } , right_type )
  • [ ] multiple names and left/right types
  • [ ] CASCADE | RESTRICT

Operator class

• [ ] CREATE OPERATOR CLASS
• [ ] ALTER OPERATOR CLASS
• [ ] DROP OPERATOR CLASS

Operator family

• [ ] CREATE OPERATOR FAMILY
• [ ] ALTER OPERATOR FAMILY
• [ ] DROP OPERATOR FAMILY