Help Center/ GaussDB(DWS)/ SQL Syntax Reference (9.1.0.x)/ Full Text Search/ Testing and Debugging Text Search/ Testing a Dictionary
Updated on 2024-09-30 GMT+08:00
View PDF

Testing a Dictionary

The ts_lexize function facilitates dictionary testing.

ts_lexize(dict regdictionary, token text) returns text[] ts_lexize returns an array of lexemes if the input token is known to the dictionary, or an empty array if the token is known to the dictionary but it is a stop word, or NULL if it is an unknown word.

For example:

1
2
3
4
5
6
7
8
9
 
SELECT ts_lexize('english_stem', 'stars');
 ts_lexize
-----------
 {star}

SELECT ts_lexize('english_stem', 'a');
 ts_lexize
-----------
 {}

The ts_lexize function expects a single token, not text.