Chris wrote:
Otandeka Simon Peter wrote:
Hi Chris,
Tried it and I get
LINE 1: SELECT * FROM s WHERE soundex(nm) = soundex('john');
HINT: No function matches the given name and argument types. You
might need to add explicit type casts.
Ahh, it's a contrib module. It's not installed by default, it's like an
external package.
See http://www.postgresql.org/docs/8.3/interactive/contrib.html for how
to install it.
Forgot to add, the package/script you want is 'fuzzystrmatch'.
--
Postgresql & php tutorials
http://www.designmagick.com/
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
