Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Strange interval arithmetic
- From: Michael Fuhr <mike(at)fuhr(dot)org>
- To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
- Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
- Subject: Re: Strange interval arithmetic
- Date: Wed, 30 Nov 2005 09:50:56 -0700
- Message-id: <20051130165056(dot)GA89793(at)winnie(dot)fuhr(dot)org>
On Sun, Nov 27, 2005 at 11:27:54AM -0700, Michael Fuhr wrote: > On Sun, Nov 27, 2005 at 08:45:18AM -0700, Michael Fuhr wrote: > > Looks like the value is stuck at 2^31 - 1 seconds: > > I see this behavior back to at least 7.3. I'd guess it's because > strtol() indicates overflow by returning LONG_MAX and setting errno > to ERANGE, but the code doesn't check for that. Is this worth looking at for the upcoming dot releases? It's apparently a longstanding behavior that almost nobody encounters, yet knowingly not addressing it seems a bit MySQLish ;-) Here's the start of the thread for anybody who missed it: http://archives.postgresql.org/pgsql-hackers/2005-11/msg01385.php -- Michael Fuhr
- Follow-Ups:
- Re: Strange interval arithmetic
- From: Tom Lane
- Re: Strange interval arithmetic
- References:
- Strange interval arithmetic
- From: Christopher Kings-Lynne
- Re: Strange interval arithmetic
- From: Michael Fuhr
- Re: Strange interval arithmetic
- From: Michael Fuhr
- Strange interval arithmetic
- Prev by Date: Re: Upcoming PG re-releases
- Next by Date: Re: Strange interval arithmetic
- Previous by thread: Re: Strange interval arithmetic
- Next by thread: Re: Strange interval arithmetic
- Indexes: