|
1 | 1 | CREATE EXTENSION hunspell_en_us; |
2 | | -SELECT ts_lexize('english_hunspell', 'stories'); |
3 | | - ts_lexize |
4 | | ------------ |
5 | | - {story} |
6 | | -(1 row) |
7 | | - |
8 | | -SELECT ts_lexize('english_hunspell', 'traveled'); |
| 2 | +CREATE TABLE table1(name varchar); |
| 3 | +INSERT INTO table1 VALUES ('stories'), ('traveled'), ('eaten'), |
| 4 | +('Saturdays'), ('healthcare'), ('generally'), |
| 5 | +('integrating'), ('lankiness'), ('rewritten'); |
| 6 | +SELECT ts_lexize('public.english_hunspell', name) FROM table1; |
9 | 7 | ts_lexize |
10 | 8 | ------------------- |
| 9 | + {story} |
11 | 10 | {traveled,travel} |
12 | | -(1 row) |
13 | | - |
14 | | -SELECT ts_lexize('english_hunspell', 'eaten'); |
15 | | - ts_lexize |
16 | | -------------- |
17 | 11 | {eaten,eat} |
18 | | -(1 row) |
19 | | - |
20 | | -SELECT ts_lexize('english_hunspell', 'I''m'); |
21 | | - ts_lexize |
22 | | ------------ |
23 | | - {i'm} |
24 | | -(1 row) |
25 | | - |
26 | | -SELECT ts_lexize('english_hunspell', 'Saturdays'); |
27 | | - ts_lexize |
28 | | ------------- |
29 | 12 | {saturday} |
30 | | -(1 row) |
31 | | - |
32 | | -SELECT ts_lexize('english_hunspell', 'healthcare'); |
33 | | - ts_lexize |
34 | | --------------- |
35 | 13 | {healthcare} |
36 | | -(1 row) |
37 | | - |
38 | | -SELECT ts_lexize('english_hunspell', 'generally'); |
39 | | - ts_lexize |
40 | | ------------ |
41 | 14 | {general} |
42 | | -(1 row) |
43 | | - |
44 | | -SELECT ts_lexize('english_hunspell', 'integrating'); |
45 | | - ts_lexize |
46 | | -------------- |
47 | 15 | {integrate} |
48 | | -(1 row) |
49 | | - |
50 | | -SELECT ts_lexize('english_hunspell', 'lankiness''s'); |
51 | | - ts_lexize |
52 | | -------------- |
53 | | - {lankiness} |
54 | | -(1 row) |
55 | | - |
56 | | -SELECT ts_lexize('english_hunspell', 'rewritten'); |
57 | | - ts_lexize |
58 | | ------------ |
| 16 | + {lankiness,lanky} |
59 | 17 | {written} |
60 | | -(1 row) |
| 18 | +(9 rows) |
| 19 | + |
| 20 | +CREATE INDEX name_idx ON table1 USING GIN (to_tsvector('public.english', "name")); |
| 21 | +SELECT d.* FROM table1 AS t, LATERAL ts_debug('public.english', t.name) AS d; |
| 22 | + alias | description | token | dictionaries | dictionary | lexemes |
| 23 | +-----------+-----------------+-------------+---------------------------------+------------------+------------------- |
| 24 | + asciiword | Word, all ASCII | stories | {english_hunspell,english_stem} | english_hunspell | {story} |
| 25 | + asciiword | Word, all ASCII | traveled | {english_hunspell,english_stem} | english_hunspell | {traveled,travel} |
| 26 | + asciiword | Word, all ASCII | eaten | {english_hunspell,english_stem} | english_hunspell | {eaten,eat} |
| 27 | + asciiword | Word, all ASCII | Saturdays | {english_hunspell,english_stem} | english_hunspell | {saturday} |
| 28 | + asciiword | Word, all ASCII | healthcare | {english_hunspell,english_stem} | english_hunspell | {healthcare} |
| 29 | + asciiword | Word, all ASCII | generally | {english_hunspell,english_stem} | english_hunspell | {general} |
| 30 | + asciiword | Word, all ASCII | integrating | {english_hunspell,english_stem} | english_hunspell | {integrate} |
| 31 | + asciiword | Word, all ASCII | lankiness | {english_hunspell,english_stem} | english_hunspell | {lankiness,lanky} |
| 32 | + asciiword | Word, all ASCII | rewritten | {english_hunspell,english_stem} | english_hunspell | {written} |
| 33 | +(9 rows) |
| 34 | + |
| 35 | +DROP INDEX name_idx; |
| 36 | +CREATE INDEX name_idx ON table1 USING GIST (to_tsvector('public.english', "name")); |
| 37 | +SELECT d.* FROM table1 AS t, LATERAL ts_debug('public.english', t.name) AS d; |
| 38 | + alias | description | token | dictionaries | dictionary | lexemes |
| 39 | +-----------+-----------------+-------------+---------------------------------+------------------+------------------- |
| 40 | + asciiword | Word, all ASCII | stories | {english_hunspell,english_stem} | english_hunspell | {story} |
| 41 | + asciiword | Word, all ASCII | traveled | {english_hunspell,english_stem} | english_hunspell | {traveled,travel} |
| 42 | + asciiword | Word, all ASCII | eaten | {english_hunspell,english_stem} | english_hunspell | {eaten,eat} |
| 43 | + asciiword | Word, all ASCII | Saturdays | {english_hunspell,english_stem} | english_hunspell | {saturday} |
| 44 | + asciiword | Word, all ASCII | healthcare | {english_hunspell,english_stem} | english_hunspell | {healthcare} |
| 45 | + asciiword | Word, all ASCII | generally | {english_hunspell,english_stem} | english_hunspell | {general} |
| 46 | + asciiword | Word, all ASCII | integrating | {english_hunspell,english_stem} | english_hunspell | {integrate} |
| 47 | + asciiword | Word, all ASCII | lankiness | {english_hunspell,english_stem} | english_hunspell | {lankiness,lanky} |
| 48 | + asciiword | Word, all ASCII | rewritten | {english_hunspell,english_stem} | english_hunspell | {written} |
| 49 | +(9 rows) |
61 | 50 |
|