Aleksander Alekseev <aleksan...@timescale.com> writes: > Got it. But in this case, what's your opinion on the differences between > date_trunc() and timezone()? Shouldn't date_trunc() be always IMMUTABLE as > well?
No, because date_trunc depends on the current timezone setting,
or at least its stable variants do.
regards, tom lane
