数据仓库服务 GAUSSDB(DWS)-CREATE TEXT SEARCH CONFIGURATION:示例

时间:2024-09-05 10:32:33

示例

创建文本搜索配置:

1
2
DROP TEXT SEARCH CONFIGURATION IF EXISTS ngram1;
CREATE TEXT SEARCH CONFIGURATION ngram1 (parser=ngram) WITH (gram_size = 2, grapsymbol_ignore = false);

创建文本搜索配置:

1
2
DROP TEXT SEARCH CONFIGURATION IF EXISTS ngram2;
CREATE TEXT SEARCH CONFIGURATION ngram2 (copy=ngram1) WITH (gram_size = 2, grapsymbol_ignore = false);

创建文本搜索配置:

1
2
DROP TEXT SEARCH CONFIGURATION IF EXISTS english_1;
CREATE TEXT SEARCH CONFIGURATION english_1 (parser=default);
support.huaweicloud.com/sqlreference-dws/dws_06_0182.html