[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


On Thu, Jun 22, 2023 at 1:13 PM Ilya Kosmodemiansky <ik@xxxxxxxxxxxxx> 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).

David J.

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux