Re: jsonpath: Inconsistency of timestamp_tz() Output

From: "David E(dot) Wheeler" <david(at)justatheory(dot)com>
To: Junwang Zhao <zhjwpku(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: jsonpath: Inconsistency of timestamp_tz() Output
Date: 2024-07-19 14:05:25
Message-ID: 630EED67-237E-4150-9EC1-CA5D2A2A2806@justatheory.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Jul 10, 2024, at 11:19, David E. Wheeler <david(at)justatheory(dot)com> wrote:

> Oh, and the time and date were wrong, too, because I blindly used the same conversion for dates as for timestamps. Fixed in v2.
>
> PR: https://github.com/theory/postgres/pull/7
> CF: https://commitfest.postgresql.org/49/5119/

Rebase on 5784a49. No other changes. I would consider this a bug in features added for 17.

Best,

David

Attachment Content-Type Size
v3-0001-Preserve-tz-when-converting-to-jsonb-timestamptz.patch application/octet-stream 4.1 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David E. Wheeler 2024-07-19 14:10:29 Re: Proposal: Document ABI Compatibility
Previous Message David E. Wheeler 2024-07-19 13:49:50 Re: Patch bug: Fix jsonpath .* on Arrays