Help Center> Data Warehouse Service> SQL Syntax Reference> Full Text Search> Testing and Debugging Text Search> Testing a Dictionary
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.