Horton

Re: jsonpath: Inconsistency of timestamp_tz() Output

Jeevan Chalke <jeevan.chalke@enterprisedb.com>

View thread
From: Jeevan Chalke <jeevan.chalke@enterprisedb.com>
To: "David E. Wheeler" <david@justatheory.com>
Cc: Junwang Zhao <zhjwpku@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2024-07-22T07:12:21Z
Lists: pgsql-hackers

Attachments

On Fri, Jul 19, 2024 at 7:35 PM David E. Wheeler <david@justatheory.com>
wrote:

> On Jul 10, 2024, at 11:19, David E. Wheeler <david@justatheory.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.
>

I agree with David that we need to set the tz explicitly as the JsonbValue
struct maintains that separately.

However, in the attached version, I have added some comments and also,
fixed some indentation.

Thanks


>
> Best,
>
> David
>
>

-- 



*Jeevan Chalke*

*Principal, ManagerProduct Development*

enterprisedb.com <https://www.enterprisedb.com>