hari.fuchs@gmail.com wrote:
> > I think the problem is that this + operator is implemented
> > by the function "timestamptz_pl_interval", which is STABLE
> > but not IMMUTABLE.
> >
> > I am not sure why this function cannot be IMMUTABLE, it
> > seems to me that it should be.
>
> No: the result of e.g.
>
> SELECT TIMESTAMPTZ '2012-10-28 01:30:00' + INTERVAL '24 hours';
>
> depends on the client's timezone and its DST rules.
You are right; timestamptz_in itself is STABLE, and I forgot
about daylight savings time.
Yours,
Laurenz Albe