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

Re: [BUGS] BUG #1993: Adding/subtracting negative time intervals

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Klint Gore <kg(at)kgb(dot)une(dot)edu(dot)au>, Michael Fuhr <mike(at)fuhr(dot)org>,Michael Glaesemann <grzm(at)myrealbox(dot)com>,Russell Smith <mr-russ(at)pws(dot)com(dot)au>, Nicholas <hb(at)x256(dot)com>,PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [BUGS] BUG #1993: Adding/subtracting negative time intervals
Date: 2005-10-26 15:27:55
Message-ID: 6527.1130340475@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Tom Lane wrote:
>> Not hardly.  I tried already.  The existing timestamp_mi behavior is
>> probably as close to 8.0 as we can get given the change in underlying
>> representation.

> You mean the '6432 hours' is a worse change, OK.

Well, it's sure not a small change, and we're still undecided whether
that's what we want in the long run.

Also, we'd have to deal with some of the other TODO items I mentioned
before we could make it work at all.  There's at least one regression
test that computes an interval larger than 2^31 hours (how do you think
I found out about that problem ;-))

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-10-26 15:30:10
Subject: Re: [BUGS] BUG #1993: Adding/subtracting negative time intervals
Previous:From: Kevin GrittnerDate: 2005-10-26 15:26:55
Subject: Re: [BUGS] BUG #1993: Adding/subtracting negative

pgsql-bugs by date

Next:From: Tom LaneDate: 2005-10-26 15:34:52
Subject: Re: Index name different from constraint name
Previous:From: Tom LaneDate: 2005-10-26 15:24:20
Subject: Re: BUG #2001: Signal 11 after concurrent inserts + updates

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