Horton

Thread

Commits

  1. doc: Fix inconsistent quotes in some jsonb fields

  1. Typo in examples in "8.14.5. jsonb Subscripting"

    The Post Office <noreply@postgresql.org> — 2022-07-07T00:27:01Z

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

  2. Re: Typo in examples in "8.14.5. jsonb Subscripting"

    Michael Paquier <michael@paquier.xyz> — 2022-07-11T01:45:45Z

    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