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