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())') → tYeah, 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
