=?iso-8859-1?Q?Conxita_Mar=EDn?= <comarin@telefonica.net> writes:
> Is this a bug?
Not if Oct 26 is a daylight savings transition day where you live.
There's been discussion of whether type interval should represent
'1 day' differently from '24 hours'. The current behavior is surely
correct for an interval of '24 hours', but arguably it's not what you
want if you say '1 day'. No one's got round to making it happen though.
In the meantime, I suspect what you are really looking for is the
date-plus-integer operation, not the date-plus-interval operation.
The latter promotes the date to a timestamp, which doesn't seem to
be what you would like.
regards, tom lane