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? The index values will still match up with the queried values if they are in the same time zone. I'm not asking to change it back to immutable (it isn't), I just realized that the stability of functions may actually be conditional. -- Alban Hertroys alban@xxxxxxxxxxxxxxxxx magproductions b.v. T: ++31(0)534346874 F: ++31(0)534346876 M: I: www.magproductions.nl A: Postbus 416 7500 AK Enschede // Integrate Your World //
