Comparing date strings with jsonpath expression

Поиск
Список
Период
Сортировка
От Tim Field
Тема Comparing date strings with jsonpath expression
Дата
Msg-id 014A028B-5CE6-4FDF-AC24-426CA6FC9CEE@mohiohio.com
обсуждение исходный текст
Ответы Re: Comparing date strings with jsonpath expression  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Comparing date strings with jsonpath expression  (jian he <jian.universality@gmail.com>)
Re: Comparing date strings with jsonpath expression  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
When using .datetime() in jsonpath expressions JSON encoded dates are not parsed, this is coupled with the fact that an error isn’t reported.

I would expect that any date encoded via JSON.stringify() would be parseable in these JSON path functions as that is after all the format that dates are very likely to be in.

If I JSON encode a date I get a value such as "2023-05-22T03:09:37.825Z” .datetime() fails to parse this due to the mircosends and timezone indicator, yet its possible to convert that with 
"2023-05-22T03:09:37.825Z”::timestamptz 

Example here of the issue, and a stackoverflow post with further discussion.



Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: BUG #17942: vacuumdb doesn't populate extended statistics on partitioned tables
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #17942: vacuumdb doesn't populate extended statistics on partitioned tables