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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster