Michael Glaesemann <grzm@myrealbox.com> writes:
> Added to this, I've been wondering whether '1 day'::interval is also
> problematic wrt daylight savings time or changing time zones.
This is exactly the point I alluded to earlier: intervals need to have
three components (months, days, seconds) not just two. That's been on
the to-do list for quite awhile. All the other units we support for
intervals bear a fixed relationship to one or another of these, so
three is sufficient.
Question to think about: should we allow fractional months or days in
the stored representation? There are some places where the existing
restriction that the months field is an integer requires awkward
compromises. On the other hand, it's not real clear what a fractional
month actually means, and similarly a fractional day is hard to assign
meaning to without positing that 1 day == 24 hours.
regards, tom lane