jsonpath Time and Timestamp Special Cases

Поиск
Список
Период
Сортировка
От David E. Wheeler
Тема jsonpath Time and Timestamp Special Cases
Дата
Msg-id 8AB7857D-BD57-472E-94F5-1964A5B15971@justatheory.com
обсуждение исходный текст
Список pgsql-hackers
Hello hackers,

I noticed that the jsonpath date/time functions (.time() and timestamp(), et al.) don’t support some valid but
special-casePostgreSQL values, notably `infinity`, `-infinity`, and, for times, '24:00:00`: 

❯ psql
psql (17devel)
Type "help" for help.

david=# select jsonb_path_query(to_jsonb('24:00:00'::time), '$.time()');
ERROR:  time format is not recognized: "24:00:00"

david=# select jsonb_path_query(to_jsonb('infinity'::timestamptz), '$.timestamp_tz()');
ERROR:  timestamp_tz format is not recognized: "infinity"

I assume this is because the standard doesn’t support these, or references JavaScript-only values or some such. Is that
right?

Best,

David




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

Предыдущее
От: Richard Guo
Дата:
Сообщение: Re: A failure in prepared_xacts test
Следующее
От: Richard Guo
Дата:
Сообщение: Re: A failure in prepared_xacts test