Re: jsonpath: Inconsistency of timestamp_tz() Output

Поиск

Список

Период

Сортировка

От	Jeevan Chalke
Тема	Re: jsonpath: Inconsistency of timestamp_tz() Output
Дата	22 июля 10:12:21
Msg-id	CAM2+6=VDEfxDz1G0kApsdqd8q_SQkr71kS8LMgZg_meiXYokmw@mail.gmail.com обсуждение исходный текст
Ответ на	Re: jsonpath: Inconsistency of timestamp_tz() Output ("David E. Wheeler" <david@justatheory.com>)
Ответы	Re: jsonpath: Inconsistency of timestamp_tz() Output
Список	pgsql-hackers

Дерево обсуждения

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