Michael Glaesemann <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster