Re: Exclusion constraints with time expressions - Mailing list pgsql-general

From hari.fuchs@gmail.com
Subject Re: Exclusion constraints with time expressions
Date
Msg-id 87fw4m7sg1.fsf@hf.protecting.net
Whole thread Raw
In response to Exclusion constraints with time expressions  (Thomas Munro <munro@ip9.org>)
Responses Re: Exclusion constraints with time expressions  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-general
"Albe Laurenz" <laurenz.albe@wien.gv.at> writes:

> 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.

pgsql-general by date:

Previous
From: Bryan Montgomery
Date:
Subject: Tuning / performance questions
Next
From: "Albe Laurenz"
Date:
Subject: Re: Exclusion constraints with time expressions