On 06/20/24 10:54, David E. Wheeler wrote:
> Still not sure about `24:00:00` as a time, though. I presume the jsonpath
> standard disallows it.
In 9075-2 9.46 "SQL/JSON path language: syntax and semantics", the behavior
of the .time() and .time_tz() and similar item methods defers to the
behavior
On Apr 29, 2024, at 20:45, David E. Wheeler wrote:
> I noticed that the jsonpath date/time functions (.time() and timestamp(), et
> al.) don’t support some valid but special-case PostgreSQL values, notably
> `infinity`, `-infinity`, and, for times, '24:00:00`:
Looking at ECMA-404[1], “The JSON
