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

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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(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:20:54
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugspgsql-hackers
Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > Keep in mind that the addition of the interval_justify_hours() did
> > generate some regression test changes, so removing
> > interval_justify_hours() might just take the results back to what we had
> > in 8.0.
> 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.

> > I guess my point is that we are changing 8.0.X behavior so we better be
> > sure it is now the way we want it to remain.
> [ shrug... ]  We've changed datetime behavior in every past release,
> we're changing it for 8.1, we'll probably change it some more for 8.2,
> and again after that.  All the datetime code is a work in progress.
> Get used to it.

OK, as long as we are sure we are not going to change it back to 8.0

  Bruce Momjian                        |
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to


pgsql-hackers by date

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

pgsql-bugs by date

Next:From: Telin LinDate: 2005-10-26 15:21:37
Subject: Re: BUG #2001: Signal 11 after concurrent inserts + updates
Previous:From: Seneca CunninghamDate: 2005-10-26 15:13:11
Subject: Re: BUG #1999: contrib/spi doesn't receive the configured

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