On 2012-11-06, Albe Laurenz <laurenz.albe@xxxxxxxxxx> wrote: > hari.fuchs@xxxxxxxxx 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. The original poster had a timestamptz constant (using the naval timezone 'Z') yet he still had the problem., -- ⚂⚃ 100% natural -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
