On Jul 10, 2024, at 10:33, David E. Wheeler <david@justatheory.com> wrote:
> Yeah I don’t know either, but now at least it’s consistent. I’ve attached a patch to fix it.
>
> Ideally, I think, we wouldn’t convert the value and determine the offset twice, but teach date_timestamptz and
timestamp_timestamptz(or date2timestamptz and timestamp2timestamptz?) how to return the offset, or create alternate
functionsthat do so. Not sure what calling style should be adopted here, but this at least addresses the issue. Happy
toresubmit something more efficient upon function design feedback.
Here’s a September CommitFest item, though I think it should be fixed before the next beta.
https://commitfest.postgresql.org/49/5119/
Best,
David