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)
[ Parent
| on HN ]
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.