Louis-David Mitterrand <cunctator(at)apartia(dot)ch> writes:
> By the way, is it normal that the "day" word doesn't appear in the interval?
> auction=# select interval(now()::abstime::int4);
> interval
> ----------------------------
> 30 years 9 mons 3 15:42:09
> (1 row)
Looks like a bug to me ... Thomas, do you agree?
Curiously, it appears that the interval input converter will accept this
with or without the 'days' keyword included.
regards, tom lane