[postmodern-devel] bug in cl-postgres/protocol.lisp?

[Bart Botta]

On 3/7/07, Marijn Haverbeke <marijnh at gmail.com> wrote:
> That's good to know -- I'll add something about that to the
> compatibility info. Did you find out in which version exactly this
> change was introduced?
>
> Marijn

Looks like it was 8.1.0.

from the 8.1 release notes at
http://www.postgresql.org/docs/8.1/interactive/release-8-1.html#AEN73858

 Add a separate day field to type interval so a one day interval can
be distinguished from a 24 hour interval (Michael Glaesemann)

Days that contain a daylight saving time adjustment are not 24 hours
long, but typically 23 or 25 hours. This change creates a conceptual
distinction between intervals of "so many days" and intervals of "so
many hours". Adding 1 day to a timestamp now gives the same local time
on the next day even if a daylight saving time adjustment occurs
between, whereas adding 24 hours will give a different local time when
this happens. For example, under US DST rules:

         '2005-04-03 00:00:00-05' + '1 day' = '2005-04-04 00:00:00-04'
         '2005-04-03 00:00:00-05' + '24 hours' = '2005-04-04 01:00:00-04'

--
Bart