DROP OPERATOR

Synopsis

Use the DROP OPERATOR statement to remove an operator.

Syntax

• Grammar
• Diagram

drop_operator ::= DROP OPERATOR [ IF EXISTS ] 
                  { operator_name ( operator_signature ) } [ , ... ] 
                  [ CASCADE | RESTRICT ]
operator_signature ::= { left_type | NONE } , { right_type | NONE }

drop_operator

operator_signature

Semantics

See the semantics of each option in the [PostgreSQL docs][postgresql-docs-drop-operator].

Examples

Basic example.

yugabyte=# CREATE OPERATOR @#@ (
             rightarg = int8,
             procedure = numeric_fac
           );
yugabyte=# DROP OPERATOR @#@ (NONE, int8);

See also

• CREATE OPERATOR
• postgresql-docs-drop-operator