Re: Strange interval arithmetic

[Michael Fuhr <mike(at)fuhr(dot)org>]

On Sun, Nov 27, 2005 at 11:15:04PM +0800, Christopher Kings-Lynne wrote:
> What's going on here?  Some sort of integer wraparound?
[...]
> test=# select interval '2378234234 seconds';
>    interval
> --------------
>  596523:14:07
> (1 row)

Looks like the value is stuck at 2^31 - 1 seconds:

test=> select interval '2147483646 seconds';  -- 2^31 - 2
   interval   
--------------
 596523:14:06
(1 row)

test=> select interval '2147483647 seconds';  -- 2^31 - 1
   interval   
--------------
 596523:14:07
(1 row)

test=> select interval '2147483648 seconds';  -- 2^31
   interval   
--------------
 596523:14:07
(1 row)

-- 
Michael Fuhr