Microsoft SQL server has two extended stored procedures that I need in Postgres: xp_nysiis and xp_metaphone. They do
fuzzymatching on strings. Are there Postgres alternatives for these? Or maybe some other way to do phonetic/fuzzy
matchingthat 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
thatis privileged, confidential or otherwise protected from disclosure. Dissemination, distribution or copying of this
e-mailor any attachments by anyone other than the intended recipient, or an employee or agent responsible for
deliveringthe message to the intended recipient, is prohibited. If you are not the intended recipient of this message
orthe employee or agent responsible for delivery of this email to the intended recipient, please notify the sender by
replyingto this message and then delete it from your system. Any use, dissemination, distribution, or reproduction of
thismessage by unintended recipients is strictly prohibited and may be unlawful.