Re: operator suggest " interval / interval = numeric"

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