On Thu, Jun 22, 2023 at 1:13 PM Ilya Kosmodemiansky <ik@dataegret.com> wrote:
Timestamp with time zone as an argument makes function not immutable because timezone could be set locally and results could differ depending on timezone
The problem here is not timezone related - it is more fundamental in that the stored data does not change but the expression, as time progresses, is going to give different values and thus make what is stored incorrect.
You should not store data that changes simply due to the passage of time (i.e., relies on external-to-the-record information).