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