Re: timestamp bug

From: Alexander Dederer <dederer(at)spb(dot)cityline(dot)ru>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: timestamp bug
Date: 2001-05-20 19:34:11
Message-ID: 9e963p$1jqh$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Cedar Cox wrote:

>
> There appears to be a bug in timestamp/interval addition. It happens in
> both PG version 7.0.2 and 7.1. There is a duplicate day (2001 Sep 07) and
> a missing day (2002 Apr 04). I discovered this by accident when I asked
> the interface I'm writing for a 365 day long calendar.. Interestingly,
> the missing day thing (second example) doesn't happen if only adding a few
> days (like the first example). I didn't go into detail to find the point
> at which it does happen.

IMN1=# SELECT version();
version
---------------------------------------------------------------
PostgreSQL 7.1.1 on i686-pc-linux-gnu, compiled by GCC 2.95.3
(1 row)

And all right work. Try new version.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Hans-Jürgen Schönig 2001-05-20 19:34:39 PL/pgSQL problem with variables
Previous Message Tom Lane 2001-05-20 17:30:44 Re: timestamp bug