summaryrefslogtreecommitdiff
path: root/contrib/fuzzystrmatch/sql/fuzzystrmatch.sql
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/fuzzystrmatch/sql/fuzzystrmatch.sql')
-rw-r--r--contrib/fuzzystrmatch/sql/fuzzystrmatch.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/contrib/fuzzystrmatch/sql/fuzzystrmatch.sql b/contrib/fuzzystrmatch/sql/fuzzystrmatch.sql
index db05c7d6b6..0b4bb9be57 100644
--- a/contrib/fuzzystrmatch/sql/fuzzystrmatch.sql
+++ b/contrib/fuzzystrmatch/sql/fuzzystrmatch.sql
@@ -6,6 +6,7 @@ SELECT soundex('hello world!');
SELECT soundex('Anne'), soundex('Ann'), difference('Anne', 'Ann');
SELECT soundex('Anne'), soundex('Andrew'), difference('Anne', 'Andrew');
SELECT soundex('Anne'), soundex('Margaret'), difference('Anne', 'Margaret');
+SELECT soundex(''), difference('', '');
SELECT levenshtein('GUMBO', 'GAMBOL');