11CREATE EXTENSION shared_ispell;
22
3- SELECT shared_ispell_mem_available();
4- SELECT shared_ispell_mem_used();
5-
63-- Test ISpell dictionary with ispell affix file
74CREATETEXT SEARCH DICTIONARY shared_ispell (
85 Template= shared_ispell,
@@ -28,9 +25,6 @@ SELECT ts_lexize('shared_ispell', 'footballklubber');
2825SELECT ts_lexize(' shared_ispell' ,' ballyklubber' );
2926SELECT ts_lexize(' shared_ispell' ,' footballyklubber' );
3027
31- SELECT shared_ispell_mem_available();
32- SELECT shared_ispell_mem_used();
33-
3428-- Test ISpell dictionary with hunspell affix file
3529CREATETEXT SEARCH DICTIONARY shared_hunspell (
3630 Template= shared_ispell,
@@ -55,13 +49,10 @@ SELECT ts_lexize('shared_hunspell', 'footballklubber');
5549SELECT ts_lexize(' shared_hunspell' ,' ballyklubber' );
5650SELECT ts_lexize(' shared_hunspell' ,' footballyklubber' );
5751
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, affixesFROM shared_ispell_dicts();
53+ SELECT stop_name, wordsFROM shared_ispell_stoplists();
6354
6455SELECT shared_ispell_reset();
6556
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 ' );