Typo in examples in "8.14.5. jsonb Subscripting"

Started by PG Bug reporting formalmost 4 years ago2 messagesdocs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

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! :-)

#2Michael Paquier
michael@paquier.xyz
In reply to: PG Bug reporting form (#1)
Re: Typo in examples in "8.14.5. jsonb Subscripting"

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