why my sounex does not work?

From: taizi <taizi2006blog(at)163(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: why my sounex does not work?
Date: 2016-08-14 16:05:18
Message-ID: 5785f0c0.439f.15689ccd88d.Coremail.taizi2006blog@163.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ondřej Světlík 2016-08-14 19:23:02 Re: why my sounex does not work?
Previous Message Murthy Nunna 2016-08-13 16:24:40 Re: Postgres v9.5.3 and v9.5.4 Unix Socket Issue