1
1
CREATE EXTENSION shared_ispell;
2
- SELECT shared_ispell_mem_available();
3
- shared_ispell_mem_available
4
- -----------------------------
5
- 1048528
6
- (1 row)
7
-
8
- SELECT shared_ispell_mem_used();
9
- shared_ispell_mem_used
10
- ------------------------
11
- 48
12
- (1 row)
13
-
14
2
-- Test ISpell dictionary with ispell affix file
15
3
CREATE TEXT SEARCH DICTIONARY shared_ispell (
16
4
Template=shared_ispell,
@@ -60,12 +48,6 @@ SELECT ts_lexize('shared_ispell', 'rebooking');
60
48
{booking,book}
61
49
(1 row)
62
50
63
- SELECT ts_lexize('shared_ispell', 'rebook');
64
- ts_lexize
65
- -----------
66
-
67
- (1 row)
68
-
69
51
SELECT ts_lexize('shared_ispell', 'unbookings');
70
52
ts_lexize
71
53
-----------
@@ -108,18 +90,6 @@ SELECT ts_lexize('shared_ispell', 'footballyklubber');
108
90
{foot,ball,klubber}
109
91
(1 row)
110
92
111
- SELECT shared_ispell_mem_available();
112
- shared_ispell_mem_available
113
- -----------------------------
114
- 980312
115
- (1 row)
116
-
117
- SELECT shared_ispell_mem_used();
118
- shared_ispell_mem_used
119
- ------------------------
120
- 68264
121
- (1 row)
122
-
123
93
-- Test ISpell dictionary with hunspell affix file
124
94
CREATE TEXT SEARCH DICTIONARY shared_hunspell (
125
95
Template=shared_ispell,
@@ -168,12 +138,6 @@ SELECT ts_lexize('shared_hunspell', 'rebooking');
168
138
{booking,book}
169
139
(1 row)
170
140
171
- SELECT ts_lexize('shared_hunspell', 'rebook');
172
- ts_lexize
173
- -----------
174
-
175
- (1 row)
176
-
177
141
SELECT ts_lexize('shared_hunspell', 'unbookings');
178
142
ts_lexize
179
143
-----------
@@ -216,29 +180,17 @@ SELECT ts_lexize('shared_hunspell', 'footballyklubber');
216
180
{foot,ball,klubber}
217
181
(1 row)
218
182
219
- SELECT shared_ispell_mem_available();
220
- shared_ispell_mem_available
221
- -----------------------------
222
- 914208
223
- (1 row)
224
-
225
- SELECT shared_ispell_mem_used();
226
- shared_ispell_mem_used
227
- ------------------------
228
- 134368
229
- (1 row)
230
-
231
- SELECT * FROM shared_ispell_dicts();
232
- dict_name | affix_name | words | affixes | bytes
233
- ---------------+-----------------+-------+---------+-------
234
- ispell_sample | hunspell_sample | 8 | 0 | 66104
235
- ispell_sample | ispell_sample | 8 | 0 | 66104
183
+ SELECT dict_name, affix_name, words, affixes FROM shared_ispell_dicts();
184
+ dict_name | affix_name | words | affixes
185
+ ---------------+-----------------+-------+---------
186
+ ispell_sample | hunspell_sample | 8 | 7
187
+ ispell_sample | ispell_sample | 8 | 7
236
188
(2 rows)
237
189
238
- SELECT * FROM shared_ispell_stoplists();
239
- stop_name | words | bytes
240
- -----------+-------+-------
241
- english | 127 | 2112
190
+ SELECT stop_name, words FROM shared_ispell_stoplists();
191
+ stop_name | words
192
+ -----------+-------
193
+ english | 127
242
194
(1 row)
243
195
244
196
SELECT shared_ispell_reset();
@@ -247,15 +199,15 @@ SELECT shared_ispell_reset();
247
199
248
200
(1 row)
249
201
250
- SELECT shared_ispell_mem_available( );
251
- shared_ispell_mem_available
252
- -----------------------------
253
- 1048528
202
+ SELECT ts_lexize('shared_ispell', 'skies' );
203
+ ts_lexize
204
+ -----------
205
+ {sky}
254
206
(1 row)
255
207
256
- SELECT shared_ispell_mem_used( );
257
- shared_ispell_mem_used
258
- ------------------------
259
- 48
208
+ SELECT ts_lexize('shared_hunspell', 'skies' );
209
+ ts_lexize
210
+ -----------
211
+ {sky}
260
212
(1 row)
261
213
0 commit comments