1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12

gaussdb=# create table table1 (c_int int,c_bigint bigint,c_varchar varchar,c_text text) with(orientation=row);

gaussdb=# create text search configuration ts_conf_1(parser=POUND);
gaussdb=# create text search configuration ts_conf_2(parser=POUND) with(split_flag='%');

gaussdb=# set default_text_search_config='ts_conf_1';
gaussdb=# create index idx1 on table1 using gin(to_tsvector(c_text));

gaussdb=# set default_text_search_config='ts_conf_2';
gaussdb=# create index idx2 on tscp_u_m_005_tbl using gin(to_tsvector(c_text));

gaussdb=# select c_varchar,to_tsvector(c_varchar) from table1 where to_tsvector(c_text) @@ plainto_tsquery('￥#@……&**')   and to_tsvector(c_text) @@ plainto_tsquery('某公司 ')   and c_varchar is not null order by 1 desc limit 3;