Re: Constraint exclusion can't process simple constant expressions?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Constraint exclusion can't process simple constant expressions?
Дата
Msg-id 4DAF8F60.9050407@agliodbs.com
обсуждение исходный текст
Ответ на Re: Constraint exclusion can't process simple constant expressions?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Constraint exclusion can't process simple constant expressions?  (Brendan Jurd <direvus@gmail.com>)
Re: Constraint exclusion can't process simple constant expressions?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Дерево обсуждения 
Tom,

> timestamptz + interval is not immutable --- in fact, the particular
> example you give (ts + '1 day') is certainly dependent on timezone
> setting.

Why not?  Given that the time zone will be the same for both the
timestamptz and the interval, how would the result not be immutable?

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Constraint exclusion can't process simple constant expressions?
Следующее
От: Brendan Jurd
Дата:
Сообщение: Re: Constraint exclusion can't process simple constant expressions?