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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
