| From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: operator suggest " interval / interval = numeric" |
| Date: | 2008-01-09 13:52:23 |
| Message-ID: | 20080109135223.GD18331@a-kretschmer.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
am Wed, dem 09.01.2008, um 17:33:00 +0700 mailte Ilya A. Kovalenko folgendes:
>
> I suggest one more standard date/time operator, to divide one interval
> by another with numeric (or float, for example) result.
> I.e. something like that:
>
> database=# SELECT '5400 seconds'::interval / '1 hour'::interval;
>
> ?column?
> ----------
> 1.5
> (1 row)
test=# SELECT extract(epoch from '5400 seconds'::interval) / extract(epoch from '1 hour'::interval);
?column?
----------
1.5
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2008-01-09 13:52:28 | Re: LD_LIBRARY_PATH not honored on Debian unstable |
| Previous Message | Markus Schiltknecht | 2008-01-09 13:25:02 | LD_LIBRARY_PATH not honored on Debian unstable |