Re: text_soundex function - Mailing list pgsql-general

From Chris
Subject Re: text_soundex function
Date
Msg-id 494A0537.7000107@gmail.com
Whole thread Raw
In response to Re: text_soundex function  ("Otandeka Simon Peter" <sotandeka@gmail.com>)
Responses Re: text_soundex function  (Chris <dmagick@gmail.com>)
List pgsql-general
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/


pgsql-general by date:

Previous
From: "Otandeka Simon Peter"
Date:
Subject: Re: text_soundex function
Next
From: Chris
Date:
Subject: Re: text_soundex function