News for hackers. Stuff that matters.
Re:Postgres AT TIME ZONE 'UTC' does NOT do what you think it... by ekejjedjndbd on Monday September 28, 2026 @08:41AM (#49877068)
If the UTC is derived why store it (unless just as a performance concern e.g. materialised view type of thing)
Re:Postgres AT TIME ZONE 'UTC' does NOT do what you think it... by christina97 on Monday September 28, 2026 @09:01AM (#49877283)
Presumably if the conversion logic changes. Eg user enters a future date in a place but the timezone in that place changes in the future.
Re:Postgres AT TIME ZONE 'UTC' does NOT do what you think it... by ekejjedjndbd on Monday September 28, 2026 @06:54PM (#49885592)
That's a good point although I would prefer to have a deterministic conversion that handles historic changes. But I get the point and having a source of truth for the conversion could be better as it won't be affected by bugs in the conversion of deemed right. It does mean maintaining two values though.