DROP OPERATOR CLASS
Synopsis
Use the DROP OPERATOR CLASS statement to remove an operator class.
Syntax
Grammar
Diagramdrop_operator_class ::= DROP OPERATOR CLASS [ IF EXISTS ]
operator_class_name USING index_method
[ CASCADE | RESTRICT ]
Semantics
See the semantics of each option in the [PostgreSQL docs][postgresql-docs-drop-operator-class].
Examples
Basic example.
yugabyte=# CREATE OPERATOR CLASS my_op_class
FOR TYPE int4
USING btree AS
OPERATOR 1 <,
OPERATOR 2 <=;
yugabyte=# DROP OPERATOR CLASS my_op_class USING btree;