- Mastering PostgreSQL 9.6
- Hans Jurgen Schonig
- 162字
- 2021-07-09 19:57:20
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.
- Internet接入·網(wǎng)絡(luò)安全
- 腦動(dòng)力:Linux指令速查效率手冊(cè)
- 工業(yè)機(jī)器人產(chǎn)品應(yīng)用實(shí)戰(zhàn)
- SCRATCH與機(jī)器人
- Mobile DevOps
- 網(wǎng)絡(luò)綜合布線設(shè)計(jì)與施工技術(shù)
- 聊天機(jī)器人:入門、進(jìn)階與實(shí)戰(zhàn)
- Visual FoxPro程序設(shè)計(jì)
- 格蠹匯編
- R Machine Learning Projects
- 精通LabVIEW程序設(shè)計(jì)
- Linux常用命令簡(jiǎn)明手冊(cè)
- 菜鳥(niǎo)起飛五筆打字高手
- 軟件測(cè)試管理
- Learn Power BI