Re: timestamp bug - Mailing list pgsql-sql

From Alexander Dederer
Subject Re: timestamp bug
Date
Msg-id 9e963p$1jqh$1@news.tht.net
Whole thread Raw
In response to timestamp bug  (Cedar Cox <cedarc@visionforisrael.com>)
List 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.


pgsql-sql by date:

Previous
From: Martín Marqués
Date:
Subject: Re: RULES
Next
From: Tubagus Nizomi
Date:
Subject: Set Datestyle