| From: | Erik Rijkers <er(at)xs4all(dot)nl> |
|---|---|
| To: | Andrew Dunstan <andrew(at)dunslane(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: JSON Functions and Operators Docs for v15 |
| Date: | 2022-05-16 19:06:59 |
| Message-ID: | 481f82a1-3e26-2740-b44a-0b3768b79b47@xs4all.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Op 16-05-2022 om 20:53 schreef Andrew Dunstan:
>
> On 2022-05-16 Mo 13:52, Erik Rijkers wrote:
>> -----
>> 2.
>>
>> This example in func.sgml says it gives 't' but on my instance it
>> returns 'f'. Is the example correct?
>>
>> jsonb_path_exists_tz('["2015-08-01 12:00:00 -05"]', '$[*] ?
>> (@.datetime() < "2015-08-02".datetime())') → t
>
> Yeah, it doesn't like the format of the timestamp literal. It works with
> "2015-08-01T12:00:0 -05". I'll fix the example in the next version.
That doesn't work either, in my hands. It seems the offending
chracteristic is the presence of the second space, before -05
> cheers
>
>
> andrew
>
>
> --
> Andrew Dunstan
> EDB: https://www.enterprisedb.com
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2022-05-16 19:33:28 | Re: JSON Functions and Operators Docs for v15 |
| Previous Message | Andrew Dunstan | 2022-05-16 19:02:27 | Re: JSON Functions and Operators Docs for v15 |