CREATE OPERATOR CLASS
Synopsis
Use the CREATE OPERATOR CLASS statement to create an operator class.
Syntax
create_operator_class ::= CREATE OPERATOR CLASS operator_class_name
[ DEFAULT ] FOR TYPE data_type USING
index_method AS operator_class_as [ , ... ]
operator_class_as ::= OPERATOR strategy_number operator_name
[ ( operator_signature ) ] [ FOR SEARCH ]
| FUNCTION support_number
[ ( op_type [ , ... ] ) ] function_name (
function_signature )
| STORAGE storage_type
create_operator_class
operator_class_as
Semantics
See the semantics of each option in the [PostgreSQL docs][postgresql-docs-create-op-class]. See the
semantics of strategy_number and support_number in another page of the [PostgreSQL
docs][postgresql-docs-xindex].
Examples
Basic example.
yugabyte=# CREATE OPERATOR CLASS my_op_class
FOR TYPE int4
USING btree AS
OPERATOR 1 <,
OPERATOR 2 <=;