summaryrefslogtreecommitdiff
path: root/contrib/fuzzystrmatch/README.soundex
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/fuzzystrmatch/README.soundex')
-rw-r--r--contrib/fuzzystrmatch/README.soundex4
1 files changed, 2 insertions, 2 deletions
diff --git a/contrib/fuzzystrmatch/README.soundex b/contrib/fuzzystrmatch/README.soundex
index b9a61495422..ec4f50fd1df 100644
--- a/contrib/fuzzystrmatch/README.soundex
+++ b/contrib/fuzzystrmatch/README.soundex
@@ -20,7 +20,7 @@ insert into s values ('wobbly')\g
select * from s
where soundex(nm) = soundex('john')\g
-select nm from s a, s b
+select a.nm, b.nm from s a, s b
where soundex(a.nm) = soundex(b.nm)
and a.oid <> b.oid\g
@@ -51,7 +51,7 @@ LANGUAGE 'sql';
DROP OPERATOR #= (text,text)\g
CREATE OPERATOR #= (leftarg=text, rightarg=text, procedure=text_sx_eq,
-commutator=text_sx_eq)\g
+commutator = #=)\g
SELECT *
FROM s