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
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
