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
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);