Обсуждение: Typo in examples in "8.14.5. jsonb Subscripting"

Поиск
Список
Период
Сортировка

Typo in examples in "8.14.5. jsonb Subscripting"

От
PG Doc comments form
Дата:
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! :-)

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

От
Michael Paquier
Дата:
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

Вложения