Updated on 2024-10-14 GMT+08:00

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
openGauss=# SELECT ts_lexize('english_stem', 'stars');
 ts_lexize
-----------
 {star}

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

The ts_lexize function expects a single token, not text.