In current sources:
regression=# select '60'::interval;
interval
----------
00:01
(1 row)
regression=# select '1.5'::interval;
interval
-------------
00:00:01.50
(1 row)
That is, '60' is read as so many hours, '1.5' is read as so many
seconds. This seems a tad inconsistent.
7.2 does the same thing, 7.1 says
ERROR: Bad interval external representation '60'
but takes '1.5' as meaning 1.5 seconds.
I'd prefer to standardize on a unit of seconds myself.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
