Re: to_char not IMMUTABLE?

Am Freitag, 12. Januar 2007 14:48 schrieb Martijn van Oosterhout:
> On Fri, Jan 12, 2007 at 11:55:07AM +0100, Mario Weilguni wrote:
> > to_char(timestamp, 'yyyy') should be constant and marked immutable,
> > or am I wrong here? Or is it not marked immutable because of possible
> > changes on date_format?
>
> AIUI, to_char is not immutable because it can be effected by external
> variables, like LC_TIME.
>
> As it is though, I'm not sure why you're using to_char here, surely
> extract or date_truc would be more appropriate?

Thanks for the info. Changing this to use extract is no real problem, I was
just curious if this is intendend behaviour.

Best regards,
Mario Weilguni