Re: jsonpath: Inconsistency of timestamp_tz() Output - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: jsonpath: Inconsistency of timestamp_tz() Output
Date
Msg-id 2494D2C0-D9F3-403C-8E1E-51D182C8FDFD@justatheory.com
Whole thread Raw
In response to Re: jsonpath: Inconsistency of timestamp_tz() Output  (Jeevan Chalke <jeevan.chalke@enterprisedb.com>)
List pgsql-hackers
On Jul 22, 2024, at 03:12, Jeevan Chalke <jeevan.chalke@enterprisedb.com> wrote:

> 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.

Thank you for the review. I changed a single word in your comments (which are welcome). Thank you!

Just to reiterate, this is not an ideal fix, as the `date_timestamptz` and `timestamp_timestamptz` perform the same
calculations.It would be nice to do it only once. 

Best,

David




Attachment

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Lock-free compaction. Why not?
Next
From: Andres Freund
Date:
Subject: Re: Vacuum ERRORs out considering freezing dead tuples from before OldestXmin