Re: why my sounex does not work?

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