Skip site navigation (1) Skip section navigation (2)

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: 2005-11-30 16:50:56
Message-ID: 20051130165056.GA89793@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
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

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-11-30 17:37:40
Subject: Re: Strange interval arithmetic
Previous:From: Tom LaneDate: 2005-11-30 16:40:30
Subject: Re: Upcoming PG re-releases

pgsql-patches by date

Next:From: Tom LaneDate: 2005-11-30 17:37:40
Subject: Re: Strange interval arithmetic
Previous:From: Michael MeskesDate: 2005-11-30 13:01:24
Subject: Re: Add missing const qualifier in ECPG

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group