v2.25 Preview Preview release - not for production v2024.2 LTS Stable release with long-term support v2024.1 STS Stable release with standard-term support v2.20 LTS Stable release with long-term support Unsupported versions

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.

Examples

Basic example.

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

See also