Time intervals overflowing?

[Oscar Morante]

I was trying to generate a sequence of timestamps from a sequence of numbers, and run into this:

   select
     596 * interval '1' hour,
     597 * interval '1' hour
   from (values 1);

   EXPR$0     |EXPR$1          |
   -----------|----------------|
   PT2145600S |PT-2145767.296S |



Cheers,

--
Oscar Morante
"Self-education is, I firmly believe, the only kind of education there is."
                                                         -- Isaac Asimov.

Notice that the second expression turns into a negative interval. Is that the expected behavior?

signature.asc
Description: Digital signature