pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedmetaphone and nysiis in postgres
7+ messages / 4 participants
[nested] [flat]
* metaphone and nysiis in postgres
@ 2007-02-07 19:46 Demel, Jeff <Jeff.Demel@JavelinDirect.com>
2007-02-07 20:08 ` Re: metaphone and nysiis in postgres Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 7+ messages in thread
From: Demel, Jeff @ 2007-02-07 19:46 UTC (permalink / raw)
To: pgsql-sql
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 Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of A. Kretschmer
Sent: Wednesday, February 07, 2007 11:45 AM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] interval as hours or minutes ?
am Wed, dem 07.02.2007, um 19:03:35 +0200 mailte Aarni Ruuhimäki folgendes:
> Hi all,
>
> Could anyone please tell an easy way to get total hours or minutes
> from an interval ?
>
> SELECT SUM(stop_date_time - start_date_time) AS tot_time FROM
> work_times WHERE user_id = 1;
Perhaps. You can, for instance, with extract(epoch from stop_date_time) retrieve the number of seconds and work with this.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
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.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: metaphone and nysiis in postgres
2007-02-07 19:46 metaphone and nysiis in postgres Demel, Jeff <Jeff.Demel@JavelinDirect.com>
@ 2007-02-07 20:08 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 7+ messages in thread
From: Tom Lane @ 2007-02-07 20:08 UTC (permalink / raw)
To: Demel, Jeff <Jeff.Demel@JavelinDirect.com>; +Cc: pgsql-sql
"Demel, Jeff" <Jeff.Demel@JavelinDirect.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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: metaphone and nysiis in postgres
@ 2007-02-07 20:13 Demel, Jeff <Jeff.Demel@JavelinDirect.com>
0 siblings, 0 replies; 7+ messages in thread
From: Demel, Jeff @ 2007-02-07 20:13 UTC (permalink / raw)
To: pgsql-sql
Ah! Cool. Contrib/fuzzystrmatch has metaphone. Looks like it has
soundex and levenschtein too.
Thanks!
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, February 07, 2007 2:09 PM
To: Demel, Jeff
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] metaphone and nysiis in postgres
"Demel, Jeff" <Jeff.Demel@JavelinDirect.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.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: metaphone and nysiis in postgres
@ 2007-02-07 20:31 Demel, Jeff <Jeff.Demel@JavelinDirect.com>
2007-02-08 09:05 ` Re: metaphone and nysiis in postgres Richard Huxton <dev@archonet.com>
0 siblings, 1 reply; 7+ messages in thread
From: Demel, Jeff @ 2007-02-07 20:31 UTC (permalink / raw)
To: pgsql-sql
Can this be installed easily on Windows?
-Jeff
-----Original Message-----
From: pgsql-sql-owner@postgresql.org
[mailto:pgsql-sql-owner@postgresql.org] 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/fuzzystrmatch has metaphone. Looks like it has
soundex and levenschtein too.
Thanks!
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, February 07, 2007 2:09 PM
To: Demel, Jeff
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] metaphone and nysiis in postgres
"Demel, Jeff" <Jeff.Demel@JavelinDirect.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.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: metaphone and nysiis in postgres
2007-02-07 20:31 Re: metaphone and nysiis in postgres Demel, Jeff <Jeff.Demel@JavelinDirect.com>
@ 2007-02-08 09:05 ` Richard Huxton <dev@archonet.com>
0 siblings, 0 replies; 7+ messages in thread
From: Richard Huxton @ 2007-02-08 09:05 UTC (permalink / raw)
To: Demel, Jeff <Jeff.Demel@JavelinDirect.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: metaphone and nysiis in postgres
@ 2007-02-08 16:59 Demel, Jeff <Jeff.Demel@JavelinDirect.com>
2007-02-08 20:48 ` Re: metaphone and nysiis in postgres Jan Muszynski <postgres@jancm.org>
0 siblings, 1 reply; 7+ messages in thread
From: Demel, Jeff @ 2007-02-08 16:59 UTC (permalink / raw)
To: pgsql-sql
I don't have a problem with doing this in our development environment,
but when we go to move it onto the live production box, with all the
live data and current custom settings, will a re-install cause issues?
Data loss is unacceptable, of course, but it would also be nice if we
don't have to juggle users, permissions, and settings.
-Jeff
-----Original Message-----
From: Richard Huxton [mailto:dev@archonet.com]
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 easily on Windows?
Try re-running the installer, it should let you tick various options to
install from contrib.
--
Richard Huxton
Archonet Ltd
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.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: metaphone and nysiis in postgres
2007-02-08 16:59 Re: metaphone and nysiis in postgres Demel, Jeff <Jeff.Demel@JavelinDirect.com>
@ 2007-02-08 20:48 ` Jan Muszynski <postgres@jancm.org>
0 siblings, 0 replies; 7+ messages in thread
From: Jan Muszynski @ 2007-02-08 20:48 UTC (permalink / raw)
To: Demel, Jeff <Jeff.Demel@JavelinDirect.com>; pgsql-sql
On 8 Feb 2007 at 10:59, Demel, Jeff wrote:
> I don't have a problem with doing this in our development environment,
> but when we go to move it onto the live production box, with all the
> live data and current custom settings, will a re-install cause issues?
> Data loss is unacceptable, of course, but it would also be nice if we
> don't have to juggle users, permissions, and settings.
>
> -Jeff
Try looking in the share\contrib subdirectory of the install folder.
Should be SQL files there to install/uninstall the contrib modules.
-jan
>
>
> -----Original Message-----
> From: Richard Huxton [mailto:dev@archonet.com]
> 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 easily on Windows?
>
> Try re-running the installer, it should let you tick various options to
> install from contrib.
>
> --
> Richard Huxton
> Archonet Ltd
> 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2007-02-08 20:48 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-02-07 19:46 metaphone and nysiis in postgres Demel, Jeff <Jeff.Demel@JavelinDirect.com>
2007-02-07 20:08 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-02-07 20:13 Re: metaphone and nysiis in postgres Demel, Jeff <Jeff.Demel@JavelinDirect.com>
2007-02-07 20:31 Re: metaphone and nysiis in postgres Demel, Jeff <Jeff.Demel@JavelinDirect.com>
2007-02-08 09:05 ` Richard Huxton <dev@archonet.com>
2007-02-08 16:59 Re: metaphone and nysiis in postgres Demel, Jeff <Jeff.Demel@JavelinDirect.com>
2007-02-08 20:48 ` Jan Muszynski <postgres@jancm.org>
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