Try our Experimental-AI powered search above!

Cross

DROP OPERATOR CLASS

Synopsis

Use the DROP OPERATOR CLASS statement to remove an operator class.

Syntax

drop_operator_class ::= DROP OPERATOR CLASS [ IF EXISTS ] operator_class_name USING index_method [ CASCADE | RESTRICT ]

drop_operator_class

DROPOPERATORCLASSIFEXISTSoperator_class_nameUSINGindex_methodCASCADERESTRICT

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;

See also