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/