[BUGS] BUG #4231: Interval silent seconds 32-bit wraparound when given as text

2008-06-09 Thread Geoff Tolley
The following bug has been logged online: Bug reference: 4231 Logged by: Geoff Tolley Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: CentOS 4.6 x86_64 (custom-compiled Linux 2.6.24.2 kernel unpatched from kernel.org) Description:Interval

Re: [BUGS] BUG #4231: Interval silent seconds 32-bit wraparound when given as text

2008-06-09 Thread Tom Lane
"Geoff Tolley" <[EMAIL PROTECTED]> writes: > When you make an interval by giving it a text representation of a number of > seconds, it appears to have a silent 32-bit wraparound (the example here is > from some raw SPSS data from a colleague; apparently it uses October 14th > 1584 as its base so th