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? Have a nice day, -- Martijn van Oosterhout <firstname.lastname@example.org> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
Description: Digital signature