Ron Mayer <rm_pg@cheapcomplexdevices.com> writes:
> Looks like the original questions from the thread
> got resolved, but I found this behaviour surprising:
> regression=# select interval '1' day to second;
> interval
> ----------
> @ 1 hour
> (1 row)
> Should this be 1 second?
That is a bit odd, especially seeing that eg. '1' hour to second
comes out as 1 second. What's making it do that?
regards, tom lane