pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedwhy my sounex does not work?
2+ messages / 2 participants
[nested] [flat]
* why my sounex does not work?
@ 2016-08-14 16:05 taizi <taizi2006blog@163.com>
0 siblings, 1 reply; 2+ messages in thread
From: taizi @ 2016-08-14 16:05 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: why my sounex does not work?
@ 2016-08-14 19:23 Ondřej Světlík <osvetlik@flexibee.eu>
parent: taizi <taizi2006blog@163.com>
0 siblings, 0 replies; 2+ messages in thread
From: Ondřej Světlík @ 2016-08-14 19:23 UTC (permalink / raw)
To: pgsql-admin; +Cc: taizi <taizi2006blog@163.com>
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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2016-08-14 19:23 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-08-14 16:05 why my sounex does not work? taizi <taizi2006blog@163.com>
2016-08-14 19:23 ` Ondřej Světlík <osvetlik@flexibee.eu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox