-
ts_stat(sqlquery text, [ weights text, ] OUT word text, OUT ndoc integer, OUT nentry integer) 描述：获取tsvector列的统计数据。 返回类型：setof record 示例： 1
2
3
4
5
6 SELECT ts_stat('select ''hello world''::tsvector');
ts_stat
-------------
(world,1,1)
(hello,1,1)
(2 rows)
-
ts_parse(parser_name text, document text, OUT tokid integer, OUT token text) 描述：测试一个解析。 返回类型：setof record 示例： 1
2
3
4
5
6
7
8 SELECT ts_parse('default', 'foo - bar');
ts_parse
-----------
(1,foo)
(12," ")
(12,"- ")
(1,bar)
(4 rows)
-
ts_token_type(parser_name text, OUT tokid integer, OUT alias text, OUT description text) 描述：获取分析器定义的记号类型。 返回类型：setof record 示例： 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27 SELECT ts_token_type('default');
ts_token_type
--------------------------------------------------------------
(1,asciiword,"Word, all ASCII")
(2,word,"Word, all letters")
(3,numword,"Word, letters and digits")
(4,email,"Email address")
(5,url,URL)
(6,host,Host)
(7,sfloat,"Scientific notation")
(8,version,"Version number")
(9,hword_numpart,"Hyphenated word part, letters and digits")
(10,hword_part,"Hyphenated word part, all letters")
(11,hword_asciipart,"Hyphenated word part, all ASCII")
(12,blank,"Space symbols")
(13,tag,"XML tag")
(14,protocol,"Protocol head")
(15,numhword,"Hyphenated word, letters and digits")
(16,asciihword,"Hyphenated word, all ASCII")
(17,hword,"Hyphenated word, all letters")
(18,url_path,"URL path")
(19,file,"File or path name")
(20,float,"Decimal notation")
(21,int,"Signed integer")
(22,uint,"Unsigned integer")
(23,entity,"XML entity")
(23 rows)
-
ts_token_type(parser_oid oid, OUT tokid integer, OUT alias text, OUT description text) 描述：获取分析器定义的记号类型。 返回类型：setof record 示例： 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27 SELECT ts_token_type(3722);
ts_token_type
--------------------------------------------------------------
(1,asciiword,"Word, all ASCII")
(2,word,"Word, all letters")
(3,numword,"Word, letters and digits")
(4,email,"Email address")
(5,url,URL)
(6,host,Host)
(7,sfloat,"Scientific notation")
(8,version,"Version number")
(9,hword_numpart,"Hyphenated word part, letters and digits")
(10,hword_part,"Hyphenated word part, all letters")
(11,hword_asciipart,"Hyphenated word part, all ASCII")
(12,blank,"Space symbols")
(13,tag,"XML tag")
(14,protocol,"Protocol head")
(15,numhword,"Hyphenated word, letters and digits")
(16,asciihword,"Hyphenated word, all ASCII")
(17,hword,"Hyphenated word, all letters")
(18,url_path,"URL path")
(19,file,"File or path name")
(20,float,"Decimal notation")
(21,int,"Signed integer")
(22,uint,"Unsigned integer")
(23,entity,"XML entity")
(23 rows)
-
ts_parse(parser_oid oid, document text, OUT tokid integer, OUT token text) 描述：测试一个解析。 返回类型：setof record 示例： 1
2
3
4
5
6
7
8 SELECT ts_parse(3722, 'foo - bar');
ts_parse
-----------
(1,foo)
(12," ")
(12,"- ")
(1,bar)
(4 rows)
-
ts_debug([ config regconfig, ] document text, OUT alias text, OUT description text, OUT token text, OUT dictionaries regdictionary[], OUT dictionary regdictionary, OUT lexemes text[]) 描述：测试一个配置。 返回类型：setof record 示例： 1
2
3
4
5
6
7
8
9 SELECT ts_debug('english', 'The Brightest supernovaes');
ts_debug
-----------------------------------------------------------------------------------
(asciiword,"Word, all ASCII",The,{english_stem},english_stem,{})
(blank,"Space symbols"," ",{},,)
(asciiword,"Word, all ASCII",Brightest,{english_stem},english_stem,{brightest})
(blank,"Space symbols"," ",{},,)
(asciiword,"Word, all ASCII",supernovaes,{english_stem},english_stem,{supernova})
(5 rows)
-
to_tsvector_for_batch([ config regconfig , ] document text) 描述：去除文件信息，并转换为tsvector类型。 返回类型：tsvector 示例： 1
2
3
4
5 gaussdb=# SELECT to_tsvector_for_batch('english', 'The Fat Rats');
to_tsvector
-----------------
'fat':2 'rat':3
(1 row)
-
ts_rewrite(query tsquery, select text) 描述：使用SELECT命令的结果替代目标中tsquery类型的单词。 返回类型：tsquery 示例： 1
2
3
4
5 gaussdb=# SELECT ts_rewrite('world'::tsquery, 'select ''world''::tsquery, ''hello''::tsquery');
ts_rewrite
------------
'hello'
(1 row)
-
ts_rank([ weights float4[], ] vector tsvector, query tsquery [, normalization integer ]) 描述：文档查询排名。 返回类型：float4 示例： 1
2
3
4
5 gaussdb=# SELECT ts_rank('hello world'::tsvector, 'world'::tsquery);
ts_rank
----------
.0607927
(1 row)
-
ts_rewrite(query tsquery, target tsquery, substitute tsquery) 描述：替换目标tsquery类型的单词。 返回类型：tsquery 示例： 1
2
3
4
5 gaussdb=# SELECT ts_rewrite('a & b'::tsquery, 'a'::tsquery, 'foo|bar'::tsquery);
ts_rewrite
-------------------------
'b' & ( 'foo' | 'bar' )
(1 row)
-
ts_rank_cd([ weights float4[], ] vector tsvector, query tsquery [, normalization integer ]) 描述：排序文件查询使用覆盖密度。 返回类型：float4 示例： 1
2
3
4
5 gaussdb=# SELECT ts_rank_cd('hello world'::tsvector,'world'::tsquery);
ts_rank_cd
------------
0
(1 row)
-
to_tsquery([ config regconfig , ] query text) 描述：标准化单词，并转换为tsquery类型。 返回类型：tsquery 示例： 1
2
3
4
5 gaussdb=# SELECT to_tsquery('english', 'The & Fat & Rats');
to_tsquery
---------------
'fat' & 'rat'
(1 row)
-
plainto_tsquery([ config regconfig , ] query text) 描述：产生tsquery类型的词汇，并忽略标点。 返回类型：tsquery 示例： 1
2
3
4
5 gaussdb=# SELECT plainto_tsquery('english', 'The Fat Rats');
plainto_tsquery
-----------------
'fat' & 'rat'
(1 row)
-
setweight(tsvector, "char") 描述：给tsvector类型的每个元素分配权值。 返回类型：tsvector 示例： 1
2
3
4
5 gaussdb=# SELECT setweight('fat:2,4 cat:3 rat:5B'::tsvector, 'A');
setweight
-------------------------------
'cat':3A 'fat':2A,4A 'rat':5A
(1 row)
-
to_tsvector([ config regconfig , ] document text) 描述：去除文件信息，并转换为tsvector类型。 返回类型：tsvector 示例： 1
2
3
4
5 gaussdb=# SELECT to_tsvector('english', 'The Fat Rats');
to_tsvector
-----------------
'fat':2 'rat':3
(1 row)
