Re: Exclusion constraints with time expressions

Поиск
Список
Период
Сортировка
От hari.fuchs@gmail.com
Тема Re: Exclusion constraints with time expressions
Дата
Msg-id 87fw4m7sg1.fsf@hf.protecting.net
обсуждение исходный текст
Ответ на Exclusion constraints with time expressions  (Thomas Munro <munro@ip9.org>)
Ответы Re: Exclusion constraints with time expressions  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Список 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 по дате отправления:

Предыдущее
От: Bryan Montgomery
Дата:
Сообщение: Tuning / performance questions
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: Exclusion constraints with time expressions