Re: metaphone and nysiis in postgres

Ah! Cool. Contrib/fuzzystrmatch has metaphone. Looks like it has
soundex and levenschtein too.

Thanks!

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Wednesday, February 07, 2007 2:09 PM
To: Demel, Jeff
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] metaphone and nysiis in postgres

"Demel, Jeff" <Jeff(dot)Demel(at)JavelinDirect(dot)com> writes:
> Microsoft SQL server has two extended stored procedures that I need in
> Postgres: xp_nysiis and xp_metaphone. They do fuzzy matching on
> strings. Are there Postgres alternatives for these?

Never heard of nysiis, but there's metaphone code in
contrib/fuzzystrmatch (along with a few other alternatives).

regards, tom lane
This email is intended only for the individual or entity to which it is addressed. This email may contain information that is privileged, confidential or otherwise protected from disclosure. Dissemination, distribution or copying of this e-mail or any attachments by anyone other than the intended recipient, or an employee or agent responsible for delivering the message to the intended recipient, is prohibited. If you are not the intended recipient of this message or the employee or agent responsible for delivery of this email to the intended recipient, please notify the sender by replying to this message and then delete it from your system. Any use, dissemination, distribution, or reproduction of this message by unintended recipients is strictly prohibited and may be unlawful.