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