On Jul 10, 2024, at 10:33, David E. Wheeler <da...@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 functions that do so. Not sure what calling style should be > adopted here, but this at least addresses the issue. Happy to resubmit > 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
