diff options
Diffstat (limited to 'contrib/fuzzystrmatch/README.soundex')
| -rw-r--r-- | contrib/fuzzystrmatch/README.soundex | 4 |
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 |
