On 3/7/07, Marijn Haverbeke marijnh@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