Re: [SQL] missing "day(s)" in interval (was: Convert from Seconds-Since-Epoch to Timestamp)

[Tom Lane]

Louis-David Mitterrand <[EMAIL PROTECTED]> 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