Interval overflow?

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Interval overflow?
Date: 2007-06-29 21:07:37
Message-ID: 1183151257.28247.46.camel@dogma.v10.wvs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is this expected behavior or a bug?

=> select version();
version
------------------------------------------------------------------------------------------------
PostgreSQL 8.2.4 on i386-portbld-freebsd6.2, compiled by GCC cc (GCC)
3.4.6 [FreeBSD] 20060305
(1 row)

=> select '2000000000 hours'::interval + '2000000000 hours'::interval;
?column?
--------------------------
-1124095576:01:49.551616
(1 row)

Regards,
Jeff Davis

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2007-06-29 21:15:56 Re: Interval overflow?
Previous Message Adam Rad?owski 2007-06-29 20:27:33 Re: i need a rad/ide open source for work with postgresql