Re: [SQL] metaphone and nysiis in postgres

2007-02-08 Thread Jan Muszynski
---Original Message- > From: Richard Huxton [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 08, 2007 3:06 AM > To: Demel, Jeff > Cc: pgsql-sql@postgresql.org > Subject: Re: [SQL] metaphone and nysiis in postgres > > Demel, Jeff wrote: > > Can this be installed

Re: [SQL] metaphone and nysiis in postgres

2007-02-08 Thread Demel, Jeff
;t have to juggle users, permissions, and settings. -Jeff -Original Message- From: Richard Huxton [mailto:[EMAIL PROTECTED] Sent: Thursday, February 08, 2007 3:06 AM To: Demel, Jeff Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] metaphone and nysiis in postgres Demel, Jeff wrote: >

Re: [SQL] metaphone and nysiis in postgres

2007-02-08 Thread Richard Huxton
Demel, Jeff wrote: Can this be installed easily on Windows? Try re-running the installer, it should let you tick various options to install from contrib. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 5: don't forget to increa

Re: [SQL] metaphone and nysiis in postgres

2007-02-07 Thread Demel, Jeff
Can this be installed easily on Windows? -Jeff -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Demel, Jeff Sent: Wednesday, February 07, 2007 2:13 PM To: pgsql-sql@postgresql.org Subject: Re: [SQL] metaphone and nysiis in postgres Ah! Cool. Contrib

Re: [SQL] metaphone and nysiis in postgres

2007-02-07 Thread Demel, Jeff
Ah! Cool. Contrib/fuzzystrmatch has metaphone. Looks like it has soundex and levenschtein too. Thanks! -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 07, 2007 2:09 PM To: Demel, Jeff Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] metaphone and

Re: [SQL] metaphone and nysiis in postgres

2007-02-07 Thread Tom Lane
"Demel, Jeff" <[EMAIL PROTECTED]> 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/

[SQL] metaphone and nysiis in postgres

2007-02-07 Thread Demel, Jeff
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? Or maybe some other way to do phonetic/fuzzy matching that would be as effective? -Jeff -Original M