官术网_书友最值得收藏!

Creating operator classes

Finally, all components are in place and it is finally possible to create the operator class needed by the index:

CREATE OPERATOR CLASS sva_special_ops 
FOR TYPE text USING btree
AS
OPERATOR 1 <# ,
OPERATOR 2 <=# ,
OPERATOR 3 = ,
OPERATOR 4 >=# ,
OPERATOR 5 ># ,

FUNCTION 1 si_same(text, text);

The CREATE OPERATOR CLASS command connects strategies and operators. OPERATOR 1 <# means that strategy 1 will use the <# operator. Finally the _same function is connected with the operator class.

Note that the operator class has a name and that it has been explicitly defined to work with B-trees.

The operator class can already be used during index creation:

CREATE INDEX idx_special ON t_sva (sva sva_special_ops);

Creating the index works in a slightly different way than previously: sva sva_special_ops means that the sva column is indexed using the sva_special_ops operator class. If sva_special_ops is not explicitly used, then PostgreSQL will not go for our special sort order but decide on the default operator class.

主站蜘蛛池模板: 兴文县| 武清区| 邳州市| 比如县| 靖江市| 长岭县| 娱乐| 乐山市| 大埔县| 滨州市| 铜陵市| 玉树县| 濮阳县| 手机| 海阳市| 丰顺县| 海伦市| 伽师县| 蚌埠市| 潜江市| 外汇| 昌图县| 左贡县| 临朐县| 武义县| 肇源县| 四平市| 石柱| 拜泉县| 基隆市| 徐闻县| 江都市| 肃北| 革吉县| 微山县| 永吉县| 兴文县| 安福县| 资中县| 泗洪县| 绥德县|