Re: Why *exactly* is date_trunc() not immutable ?

Поиск
Список
Период
Сортировка
От Michael Glaesemann
Тема Re: Why *exactly* is date_trunc() not immutable ?
Дата
Msg-id 78C0B131-604A-40AD-8C09-B59CF407E7D1@seespotcode.net
обсуждение исходный текст
Ответ на Re: Why *exactly* is date_trunc() not immutable ?  (Alban Hertroys <alban@magproductions.nl>)
Ответы Re: Why *exactly* is date_trunc() not immutable ?  (Alban Hertroys <alban@magproductions.nl>)
Список pgsql-general
On Feb 19, 2007, at 18:04 , Alban Hertroys wrote:

> Michael Glaesemann wrote:
>>
>> On Feb 18, 2007, at 20:29 , Karsten Hilbert wrote:
>>
>>> What I don't understand, however, is exactly *why* date_trunc is not
>>> immutable ?
>>
>> I believe it's because the result of date_trunc depends on the
>> time zone
>> setting for the session.
>
> I understand the reasoning, but _under the conditions_ it is being
> used
> by the OP it could have been immutable, right?

*Under the conditions* doesn't really make sense wrt immutable
functions. Immutable means is immutable under all conditions.

Michael Glaesemann
grzm seespotcode net



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

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: Why *exactly* is date_trunc() not immutable ?
Следующее
От: Michael Glaesemann
Дата:
Сообщение: Re: Why *exactly* is date_trunc() not immutable ?