1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
|
--- a/expected/test1.out
+++ b/expected/test1.out
@@ -2,12 +2,7 @@
-- pg_similarity
-- testing similarity functions and operators
--
---
--- Turn off echoing so that expected file does not depend on contents of
--- this file
---
-SET client_min_messages to warning;
-\set ECHO none
+CREATE EXTENSION pg_similarity;
\set a '\'Euler Taveira de Oliveira\''
\set b '\'Euler T Oliveira\''
\set c '\'Oiler Taviera do Oliviera\''
--- a/sql/test1.sql
+++ b/sql/test1.sql
@@ -3,15 +3,7 @@
-- testing similarity functions and operators
--
---
--- Turn off echoing so that expected file does not depend on contents of
--- this file
---
-SET client_min_messages to warning;
-\set ECHO none
-\i pg_similarity.sql
-RESET client_min_messages;
-\set ECHO all
+CREATE EXTENSION pg_similarity;
\set a '\'Euler Taveira de Oliveira\''
\set b '\'Euler T Oliveira\''
--- a/expected/test2.out
+++ b/expected/test2.out
@@ -7,6 +7,7 @@
--
RESET client_min_messages;
\set ECHO all
+LOAD 'pg_similarity';
--
-- errors
--
--- a/sql/test2.sql
+++ b/sql/test2.sql
@@ -9,6 +9,8 @@
RESET client_min_messages;
\set ECHO all
+LOAD 'pg_similarity';
+
--
-- errors
--
--- a/expected/test3.out
+++ b/expected/test3.out
@@ -21,12 +21,6 @@ INSERT INTO simtst (a) VALUES
('Oliveira, E. T.'),
('ETO');
-- Levenshtein
-SHOW pg_similarity.levenshtein_threshold;
- pg_similarity.levenshtein_threshold
--------------------------------------
- 0.7
-(1 row)
-
SELECT a FROM simtst WHERE a ~== :a;
a
---------------------------
@@ -36,6 +30,12 @@ SELECT a FROM simtst WHERE a ~== :a;
EULER TAVEIRA OLIVEIRA
(4 rows)
+SHOW pg_similarity.levenshtein_threshold;
+ pg_similarity.levenshtein_threshold
+-------------------------------------
+ 0.7
+(1 row)
+
SET pg_similarity.levenshtein_threshold to 0.4;
SHOW pg_similarity.levenshtein_threshold;
pg_similarity.levenshtein_threshold
--- a/sql/test3.sql
+++ b/sql/test3.sql
@@ -26,8 +26,8 @@ INSERT INTO simtst (a) VALUES
('ETO');
-- Levenshtein
-SHOW pg_similarity.levenshtein_threshold;
SELECT a FROM simtst WHERE a ~== :a;
+SHOW pg_similarity.levenshtein_threshold;
SET pg_similarity.levenshtein_threshold to 0.4;
SHOW pg_similarity.levenshtein_threshold;
SELECT a FROM simtst WHERE a ~== :a;
|
