DROP OPERATOR
This page documents a preview version.
v2.23 Preview
Preview includes features under active development and is for development and testing only.
For production, use the latest stable version (v2024.1).
For production, use the latest stable version (v2024.1).
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 }
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);