Re: JSON Functions and Operators Docs for v15

Op 16-05-2022 om 16:49 schreef Andrew Dunstan:

> [sqljson-dox-rework-2.patch]

Two issues, derived from func.sgml:

-----
1.

I noticed that some json functions, for instance json_object(), in their 
output insert unexpected spaces before the separator-colon:

testdb=# select json_object('{a, 1, b, "def", c, 3.5}');

               json_object
---------------------------------------
  {"a" : "1", "b" : "def", "c" : "3.5"}
(1 row)

instead of the expected
  {"a": "1", "b": "def", "c": "3.5"}

Of course not outright wrong but wouldn't it make more sense to 
normalize such output?  There is here no reason in the input to space 
the colon on both sides.

Functions that yield this peculiarly spaced output are:
   json_object
   json_objectagg
   json_build_object

-----
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


Thanks,

Erik


> andrew
> 
> --
> Andrew Dunstan
> EDB: https://www.enterprisedb.com