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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org