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

Commit6141123

Browse files
committed
fuzzystrmatch: Add test suite
Reviewed-by: David Steele <david@pgmasters.net>
1 parentb28dfa6 commit6141123

File tree

5 files changed

+98
-4
lines changed

5 files changed

+98
-4
lines changed

‎contrib/fuzzystrmatch/.gitignore‎

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,4 @@
1+
# Generated subdirectories
2+
/log/
3+
/results/
4+
/tmp_check/

‎contrib/fuzzystrmatch/Makefile‎

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -8,6 +8,8 @@ DATA = fuzzystrmatch--1.1.sql fuzzystrmatch--1.0--1.1.sql \
88
fuzzystrmatch--unpackaged--1.0.sql
99
PGFILEDESC = "fuzzystrmatch - similarities and distance between strings"
1010

11+
REGRESS = fuzzystrmatch
12+
1113
ifdefUSE_PGXS
1214
PG_CONFIG = pg_config
1315
PGXS :=$(shell$(PG_CONFIG) --pgxs)
Lines changed: 67 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,67 @@
1+
CREATE EXTENSION fuzzystrmatch;
2+
SELECT soundex('hello world!');
3+
soundex
4+
---------
5+
H464
6+
(1 row)
7+
8+
SELECT soundex('Anne'), soundex('Ann'), difference('Anne', 'Ann');
9+
soundex | soundex | difference
10+
---------+---------+------------
11+
A500 | A500 | 4
12+
(1 row)
13+
14+
SELECT soundex('Anne'), soundex('Andrew'), difference('Anne', 'Andrew');
15+
soundex | soundex | difference
16+
---------+---------+------------
17+
A500 | A536 | 2
18+
(1 row)
19+
20+
SELECT soundex('Anne'), soundex('Margaret'), difference('Anne', 'Margaret');
21+
soundex | soundex | difference
22+
---------+---------+------------
23+
A500 | M626 | 0
24+
(1 row)
25+
26+
SELECT levenshtein('GUMBO', 'GAMBOL');
27+
levenshtein
28+
-------------
29+
2
30+
(1 row)
31+
32+
SELECT levenshtein('GUMBO', 'GAMBOL', 2, 1, 1);
33+
levenshtein
34+
-------------
35+
3
36+
(1 row)
37+
38+
SELECT levenshtein_less_equal('extensive', 'exhaustive', 2);
39+
levenshtein_less_equal
40+
------------------------
41+
3
42+
(1 row)
43+
44+
SELECT levenshtein_less_equal('extensive', 'exhaustive', 4);
45+
levenshtein_less_equal
46+
------------------------
47+
4
48+
(1 row)
49+
50+
SELECT metaphone('GUMBO', 4);
51+
metaphone
52+
-----------
53+
KM
54+
(1 row)
55+
56+
SELECT dmetaphone('gumbo');
57+
dmetaphone
58+
------------
59+
KMP
60+
(1 row)
61+
62+
SELECT dmetaphone_alt('gumbo');
63+
dmetaphone_alt
64+
----------------
65+
KMP
66+
(1 row)
67+
Lines changed: 21 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,21 @@
1+
CREATE EXTENSION fuzzystrmatch;
2+
3+
4+
SELECT soundex('hello world!');
5+
6+
SELECT soundex('Anne'), soundex('Ann'), difference('Anne','Ann');
7+
SELECT soundex('Anne'), soundex('Andrew'), difference('Anne','Andrew');
8+
SELECT soundex('Anne'), soundex('Margaret'), difference('Anne','Margaret');
9+
10+
11+
SELECT levenshtein('GUMBO','GAMBOL');
12+
SELECT levenshtein('GUMBO','GAMBOL',2,1,1);
13+
SELECT levenshtein_less_equal('extensive','exhaustive',2);
14+
SELECT levenshtein_less_equal('extensive','exhaustive',4);
15+
16+
17+
SELECT metaphone('GUMBO',4);
18+
19+
20+
SELECT dmetaphone('gumbo');
21+
SELECT dmetaphone_alt('gumbo');

‎doc/src/sgml/fuzzystrmatch.sgml‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -133,19 +133,19 @@ test=# SELECT levenshtein('GUMBO', 'GAMBOL');
133133
2
134134
(1 row)
135135

136-
test=# SELECT levenshtein('GUMBO', 'GAMBOL', 2,1,1);
136+
test=# SELECT levenshtein('GUMBO', 'GAMBOL', 2, 1,1);
137137
levenshtein
138138
-------------
139139
3
140140
(1 row)
141141

142-
test=# SELECT levenshtein_less_equal('extensive', 'exhaustive',2);
142+
test=# SELECT levenshtein_less_equal('extensive', 'exhaustive',2);
143143
levenshtein_less_equal
144144
------------------------
145145
3
146146
(1 row)
147147

148-
test=# SELECT levenshtein_less_equal('extensive', 'exhaustive',4);
148+
test=# SELECT levenshtein_less_equal('extensive', 'exhaustive',4);
149149
levenshtein_less_equal
150150
------------------------
151151
4
@@ -227,7 +227,7 @@ dmetaphone_alt(text source) returns text
227227
</para>
228228

229229
<screen>
230-
test=#select dmetaphone('gumbo');
230+
test=#SELECT dmetaphone('gumbo');
231231
dmetaphone
232232
------------
233233
KMP

0 commit comments

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