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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
