Try our Experimental-AI powered search above!

Cross

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 [ , ... ] ) ] subprogram_name ( subprogram_signature ) | STORAGE storage_type

create_operator_class

CREATEOPERATORCLASSoperator_class_nameDEFAULTFORTYPEdata_typeUSINGindex_methodAS,operator_class_as

operator_class_as

OPERATORstrategy_numberoperator_name(operator_signature)FORSEARCHFUNCTIONsupport_number(,op_type)subprogram_name(subprogram_signature)STORAGEstorage_type

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 <=;

See also