Обсуждение: why my sounex does not work?

Поиск
Список
Период
Сортировка

why my sounex does not work?

От
taizi
Дата:
Hi Everybody,
this is my first time to ask question on mail list about question of DB.
i JUST start to read a book from ben forta, which sql in 10.
The quetion is while i type as scrip in books on following:
SELECT CUST_NAME, CUST_CONTACT
FROM CUSTOMERS
WHERE SOUNDEX(CUST_CONTACT) =SOUNDEX(' MICHAEL GREEN');
The result is not same as shown in book.
My psql remind me that      sound(character) does not exist.
how can i deal with it? My psql version is 9.5
your sincerely
edison


 

Re: why my sounex does not work?

От
Ondřej Světlík
Дата:
Dne 14.8.2016 v 18:05 taizi napsal(a):
> Hi Everybody,
> this is my first time to ask question on mail list about question of DB.
> i JUST start to read a book from ben forta, which sql in 10.
> The quetion is while i type as scrip in books on following:
> SELECT CUST_NAME, CUST_CONTACT
> FROM CUSTOMERS
> WHERE SOUNDEX(CUST_CONTACT) =SOUNDEX(' MICHAEL GREEN');
> The result is not same as shown in book.
> My psql remind me that      sound(character) does not exist.
> how can i deal with it? My psql version is 9.5
> your sincerely
> edison
>
>
>
>

Ho Edison,

do you have postgresql-contrib installed? Did you create the extension?

CREATE EXTENSION fuzzystrmatch;

Regards

Ondřej