Re: Why *exactly* is date_trunc() not immutable ? - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: Why *exactly* is date_trunc() not immutable ?
Date
Msg-id 78C0B131-604A-40AD-8C09-B59CF407E7D1@seespotcode.net
Whole thread Raw
In response to Re: Why *exactly* is date_trunc() not immutable ?  (Alban Hertroys <alban@magproductions.nl>)
Responses Re: Why *exactly* is date_trunc() not immutable ?  (Alban Hertroys <alban@magproductions.nl>)
List 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 by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Why *exactly* is date_trunc() not immutable ?
Next
From: Michael Glaesemann
Date:
Subject: Re: Why *exactly* is date_trunc() not immutable ?