Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitbedf43c

Browse files
committed
Merged in test and doc updates for dictionaries as contrib modules
2 parents8cbfaba +ac254bd commitbedf43c

35 files changed

+433
-391272
lines changed

‎contrib/Makefile‎

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -25,7 +25,6 @@ SUBDIRS = \
2525
hunspell_fr\
2626
hunspell_nl_nl\
2727
hunspell_ru_ru\
28-
hunspell_tr_tr\
2928
intagg\
3029
intarray\
3130
isn\

‎contrib/hunspell_en_us/Makefile‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11
EXTENSION = hunspell_en_us
2-
DATA = hunspell_en_us--1.0.sql
2+
DATA =sql/hunspell_en_us--1.0.sql
33

4-
DATA_TSEARCH = en_us.affix en_us.dict
4+
DATA_TSEARCH =dict/en_us.affixdict/en_us.dict
55

66
REGRESS = hunspell_en_us
77

Lines changed: 68 additions & 52 deletions
Original file line numberDiff line numberDiff line change
@@ -1,61 +1,77 @@
11
CREATE EXTENSION hunspell_en_us;
2-
SELECT ts_lexize('english_hunspell', 'stories');
3-
ts_lexize
4-
-----------
5-
{story}
6-
(1 row)
2+
CREATE TABLE table1(name varchar);
3+
INSERT INTO table1 VALUES ('leaves'), ('leaved'), ('leaving'),
4+
('inability'), ('abilities'), ('disability'), ('ability');
5+
SELECT d.* FROM table1 AS t, LATERAL ts_debug('public.english', t.name) AS d;
6+
alias | description | token | dictionaries | dictionary | lexemes
7+
-----------+-----------------+------------+---------------------------------+------------------+-----------
8+
asciiword | Word, all ASCII | leaves | {english_hunspell,english_stem} | english_hunspell | {leave}
9+
asciiword | Word, all ASCII | leaved | {english_hunspell,english_stem} | english_hunspell | {leave}
10+
asciiword | Word, all ASCII | leaving | {english_hunspell,english_stem} | english_hunspell | {leave}
11+
asciiword | Word, all ASCII | inability | {english_hunspell,english_stem} | english_hunspell | {ability}
12+
asciiword | Word, all ASCII | abilities | {english_hunspell,english_stem} | english_hunspell | {ability}
13+
asciiword | Word, all ASCII | disability | {english_hunspell,english_stem} | english_hunspell | {ability}
14+
asciiword | Word, all ASCII | ability | {english_hunspell,english_stem} | english_hunspell | {ability}
15+
(7 rows)
716

8-
SELECT ts_lexize('english_hunspell', 'traveled');
9-
ts_lexize
10-
-------------------
11-
{traveled,travel}
12-
(1 row)
17+
CREATE INDEX name_idx ON table1 USING GIN (to_tsvector('public.english', "name"));
18+
SELECT * FROM table1 WHERE to_tsvector('public.english', name)
19+
@@ to_tsquery('public.english', 'leaving');
20+
name
21+
---------
22+
leaves
23+
leaved
24+
leaving
25+
(3 rows)
1326

14-
SELECT ts_lexize('english_hunspell', 'eaten');
15-
ts_lexize
16-
-------------
17-
{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
27+
SELECT * FROM table1 WHERE to_tsvector('public.english', name)
28+
@@ to_tsquery('public.english', 'abilities');
29+
name
2830
------------
29-
{saturday}
30-
(1 row)
31-
32-
SELECT ts_lexize('english_hunspell', 'healthcare');
33-
ts_lexize
34-
--------------
35-
{healthcare}
36-
(1 row)
31+
inability
32+
abilities
33+
disability
34+
ability
35+
(4 rows)
3736

38-
SELECT ts_lexize('english_hunspell', 'generally');
39-
ts_lexize
40-
-----------
41-
{general}
42-
(1 row)
37+
SELECT * FROM table1 WHERE to_tsvector('public.english', name)
38+
@@ to_tsquery('public.english', 'ability');
39+
name
40+
------------
41+
inability
42+
abilities
43+
disability
44+
ability
45+
(4 rows)
4346

44-
SELECT ts_lexize('english_hunspell', 'integrating');
45-
ts_lexize
46-
-------------
47-
{integrate}
48-
(1 row)
47+
DROP INDEX name_idx;
48+
CREATE INDEX name_idx ON table1 USING GIST (to_tsvector('public.english', "name"));
49+
SELECT * FROM table1 WHERE to_tsvector('public.english', name)
50+
@@ to_tsquery('public.english', 'leaving');
51+
name
52+
---------
53+
leaves
54+
leaved
55+
leaving
56+
(3 rows)
4957

50-
SELECT ts_lexize('english_hunspell', 'lankiness''s');
51-
ts_lexize
52-
-------------
53-
{lankiness}
54-
(1 row)
58+
SELECT * FROM table1 WHERE to_tsvector('public.english', name)
59+
@@ to_tsquery('public.english', 'abilities');
60+
name
61+
------------
62+
inability
63+
abilities
64+
disability
65+
ability
66+
(4 rows)
5567

56-
SELECT ts_lexize('english_hunspell', 'rewritten');
57-
ts_lexize
58-
-----------
59-
{written}
60-
(1 row)
68+
SELECT * FROM table1 WHERE to_tsvector('public.english', name)
69+
@@ to_tsquery('public.english', 'ability');
70+
name
71+
------------
72+
inability
73+
abilities
74+
disability
75+
ability
76+
(4 rows)
6177

File renamed without changes.
Lines changed: 22 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -1,12 +1,24 @@
11
CREATE EXTENSION hunspell_en_us;
22

3-
SELECT ts_lexize('english_hunspell','stories');
4-
SELECT ts_lexize('english_hunspell','traveled');
5-
SELECT ts_lexize('english_hunspell','eaten');
6-
SELECT ts_lexize('english_hunspell','I''m');
7-
SELECT ts_lexize('english_hunspell','Saturdays');
8-
SELECT ts_lexize('english_hunspell','healthcare');
9-
SELECT ts_lexize('english_hunspell','generally');
10-
SELECT ts_lexize('english_hunspell','integrating');
11-
SELECT ts_lexize('english_hunspell','lankiness''s');
12-
SELECT ts_lexize('english_hunspell','rewritten');
3+
CREATETABLEtable1(namevarchar);
4+
INSERT INTO table1VALUES ('leaves'), ('leaved'), ('leaving'),
5+
('inability'), ('abilities'), ('disability'), ('ability');
6+
7+
SELECT d.*FROM table1AS t, LATERAL ts_debug('public.english',t.name)AS d;
8+
9+
CREATEINDEXname_idxON table1 USING GIN (to_tsvector('public.english',"name"));
10+
SELECT*FROM table1WHERE to_tsvector('public.english', name)
11+
@@ to_tsquery('public.english','leaving');
12+
SELECT*FROM table1WHERE to_tsvector('public.english', name)
13+
@@ to_tsquery('public.english','abilities');
14+
SELECT*FROM table1WHERE to_tsvector('public.english', name)
15+
@@ to_tsquery('public.english','ability');
16+
17+
DROPINDEX name_idx;
18+
CREATEINDEXname_idxON table1 USING GIST (to_tsvector('public.english',"name"));
19+
SELECT*FROM table1WHERE to_tsvector('public.english', name)
20+
@@ to_tsquery('public.english','leaving');
21+
SELECT*FROM table1WHERE to_tsvector('public.english', name)
22+
@@ to_tsquery('public.english','abilities');
23+
SELECT*FROM table1WHERE to_tsvector('public.english', name)
24+
@@ to_tsquery('public.english','ability');

‎contrib/hunspell_fr/Makefile‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11
EXTENSION = hunspell_fr
2-
DATA = hunspell_fr--1.0.sql
2+
DATA =sql/hunspell_fr--1.0.sql
33

4-
DATA_TSEARCH = fr.affix fr.dict
4+
DATA_TSEARCH =dict/fr.affixdict/fr.dict
55

66
REGRESS = hunspell_fr
77

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp