Re: Strange interval arithmetic - Mailing list pgsql-hackers

From Michael Fuhr
Subject Re: Strange interval arithmetic
Date
Msg-id 20051130165056.GA89793@winnie.fuhr.org
Whole thread Raw
In response to Re: Strange interval arithmetic  (Michael Fuhr <mike@fuhr.org>)
Responses Re: Strange interval arithmetic  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Upcoming PG re-releases
Next
From: Tom Lane
Date:
Subject: Re: Strange interval arithmetic