Re: missing "day(s)" in interval (was: Convert from Seconds-Since-Epoch to Timestamp) - Mailing list pgsql-sql

Louis-David Mitterrand <cunctator@apartia.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