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.
yet the data type of the nm is text.
I am using 8.3.1.
Anything am doing wrong?
On Thu, Dec 18, 2008 at 10:26 AM, Chris <dmagick(at)gmail(dot)com> wrote:
> Otandeka Simon Peter wrote:
>
>> Does this function(text_soundex) exist in the latest Postgresql versions
>> or it was replaced?
>>
>
> It's called soundex:
>
> http://www.postgresql.org/docs/8.3/interactive/fuzzystrmatch.html
>
> --
> Postgresql & php tutorials
> http://www.designmagick.com/
>
>