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)
Ilya A. Kovalenko
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
