Re: timestamp bug

Richard Huxton <dev@archonet.com>

From: Richard Huxton <dev@archonet.com>
To: Cedar Cox <cedarc@visionforisrael.com>
Cc: pgsql-sql@postgresql.org
Date: 2001-05-20T12:29:54Z
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.

you're not hitting an issue with clocks going forward/back for
summertime/daylight savings time?

- Richard Huxton