1
1
CREATE EXTENSION shared_ispell;
2
2
3
- SELECT shared_ispell_mem_available();
4
- SELECT shared_ispell_mem_used();
5
-
6
3
-- Test ISpell dictionary with ispell affix file
7
4
CREATE TEXT SEARCH DICTIONARY shared_ispell (
8
5
Template= shared_ispell,
@@ -28,9 +25,6 @@ SELECT ts_lexize('shared_ispell', 'footballklubber');
28
25
SELECT ts_lexize(' shared_ispell' , ' ballyklubber' );
29
26
SELECT ts_lexize(' shared_ispell' , ' footballyklubber' );
30
27
31
- SELECT shared_ispell_mem_available();
32
- SELECT shared_ispell_mem_used();
33
-
34
28
-- Test ISpell dictionary with hunspell affix file
35
29
CREATE TEXT SEARCH DICTIONARY shared_hunspell (
36
30
Template= shared_ispell,
@@ -55,13 +49,10 @@ SELECT ts_lexize('shared_hunspell', 'footballklubber');
55
49
SELECT ts_lexize(' shared_hunspell' , ' ballyklubber' );
56
50
SELECT ts_lexize(' shared_hunspell' , ' footballyklubber' );
57
51
58
- SELECT shared_ispell_mem_available();
59
- SELECT shared_ispell_mem_used();
60
-
61
- SELECT * FROM shared_ispell_dicts();
62
- SELECT * FROM shared_ispell_stoplists();
52
+ SELECT dict_name, affix_name, words, affixes FROM shared_ispell_dicts();
53
+ SELECT stop_name, words FROM shared_ispell_stoplists();
63
54
64
55
SELECT shared_ispell_reset();
65
56
66
- SELECT shared_ispell_mem_available( );
67
- SELECT shared_ispell_mem_used( );
57
+ SELECT ts_lexize( ' shared_ispell ' , ' skies ' );
58
+ SELECT ts_lexize( ' shared_hunspell ' , ' skies ' );
0 commit comments