-- 安裝擴(kuò)展
CREATE EXTENSION dict_int;
-- 驗(yàn)證安裝
SELECT extname FROM pg_extension WHERE extname = 'dict_int';

CREATE TEXT SEARCH DICTIONARY intdict (
    TEMPLATE = dict_int,
    -- 可選參數(shù)
    MAXLEN = 10,       -- 最大整數(shù)位數(shù)(默認(rèn)無(wú)限制)
    REJECTLONG = true  -- 是否拒絕過(guò)長(zhǎng)整數(shù)(默認(rèn)false)
);

-- 創(chuàng)建只接受5位以內(nèi)整數(shù)的字典
CREATE TEXT SEARCH DICTIONARY intdict_5digit (
    TEMPLATE = dict_int,
    MAXLEN = 5,
    REJECTLONG = true
);
-- 創(chuàng)建接受所有整數(shù)的字典
CREATE TEXT SEARCH DICTIONARY intdict_all (
    TEMPLATE = dict_int
);

-- 創(chuàng)建包含整數(shù)字典的配置
CREATE TEXT SEARCH CONFIGURATION mycfg (COPY = simple);
ALTER TEXT SEARCH CONFIGURATION mycfg
    ALTER MAPPING FOR int, uint WITH intdict;

-- 測(cè)試字典效果
SELECT ts_lexize('intdict', '12345');  -- 返回: {12345}
SELECT ts_lexize('intdict', 'abc123'); -- 返回: {} (只匹配純整數(shù))
-- 在查詢中使用
SELECT * FROM documents 
WHERE to_tsvector('mycfg', content) @@ to_tsquery('mycfg', '123');

-- 配置專門處理產(chǎn)品編號(hào)的搜索
CREATE TEXT SEARCH CONFIGURATION product_search (COPY = simple);
ALTER TEXT SEARCH CONFIGURATION product_search
    ALTER MAPPING FOR int, uint WITH intdict_5digit, simple;
-- 查詢示例
SELECT * FROM products
WHERE to_tsvector('product_search', product_code) @@ '12345';

-- 配置日志分析搜索(包含狀態(tài)碼和消息)
CREATE TEXT SEARCH CONFIGURATION log_search (COPY = simple);
ALTER TEXT SEARCH CONFIGURATION log_search
    ALTER MAPPING FOR int, uint WITH intdict,
    ALTER MAPPING FOR asciiword WITH english_stem;
-- 查詢狀態(tài)碼200的日志
SELECT * FROM server_logs
WHERE to_tsvector('log_search', log_message) @@ '200';