DROP OPERATOR

Synopsis

Use the DROP OPERATOR statement to remove an operator.

Syntax

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

operator_signature ::= { left_type | NONE } , { right_type | NONE }

drop_operator

DROPOPERATORIFEXISTS,operator_name(operator_signature)CASCADERESTRICT

operator_signature

left_typeNONE,right_typeNONE

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