Thomas Lockhart <[EMAIL PROTECTED]> writes:
>> That is, '60' is read as so many hours, '1.5' is read as so many
>> seconds. This seems a tad inconsistent.
> They fulfill two separate use cases. Time zones can now be specified as
> intervals, and the default unit must be hours. A number with a de
...
> That is, '60' is read as so many hours, '1.5' is read as so many
> seconds. This seems a tad inconsistent.
They fulfill two separate use cases. Time zones can now be specified as
intervals, and the default unit must be hours. A number with a decimal
point is usually in units of seconds, an
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
