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.
-- Postgresql & php tutorials http://www.designmagick.com/ -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
