hari.fu...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
