Typo in examples in "8.14.5. jsonb Subscripting"
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! :-)
On Thu, Jul 07, 2022 at 12:27:01AM +0000, PG Doc comments form wrote:
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}]}
Indeed. I can see only the two places you are pointing at as being
incorrect. Will fix.
--
Michael