Re: text_soundex function
| От | Otandeka Simon Peter |
|---|---|
| Тема | Re: text_soundex function |
| Дата | |
| Msg-id | efc321cd0812180003le982ec0t528f39b83ee2b126@mail.gmail.com обсуждение |
| Ответ на | Re: text_soundex function (Chris <dmagick@gmail.com>) |
| Ответы |
Re: text_soundex function
|
| Список | pgsql-general |
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?
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@gmail.com> wrote:
Otandeka Simon Peter wrote:It's called soundex:Does this function(text_soundex) exist in the latest Postgresql versions or it was replaced?
http://www.postgresql.org/docs/8.3/interactive/fuzzystrmatch.html
--
Postgresql & php tutorials
http://www.designmagick.com/
В списке pgsql-general по дате отправления: