Ouch. Ok, that looks like it. I guess I should just set the time part to
13:00 (when DST never changes)? Or, can I set the time zone to GMT (for
this single SQL statement) or something that doesn't have DST? Perhaps a
different data type? Suggestions?
Thanks,
-Cedar
On Sun, 20 May 2001, Richard Huxton wrote:
> 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
>