The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/14/datatype-json.html
Description:
Towards the end of the section, the code examples given have comments where
the JSON is using single quotes instead of double quotes around the
properties. For example this:
-- Where jsonb_field was {}, it is now {'a': [{'b': 1}]}
...should use double quotes around the "a" and "b" properties and read as
follows:
-- Where jsonb_field was {}, it is now {"a": [{"b": 1}]}
Likewise, this:
-- Where jsonb_field was [], it is now [null, {'a': 1}]
..should use double quotes around the "a" property and read as follows:
-- Where jsonb_field was [], it is now [null, {"a": 1}]
Many thanks,
Eric Mutta.
PS: hats off to the amazing people who write these docs - the json-related
docs are **incredibly thorough** to the point of being overwhelming! :-)