diff options
| author | Michael Paquier <michael@paquier.xyz> | 2022-07-11 10:56:48 +0900 |
|---|---|---|
| committer | Michael Paquier <michael@paquier.xyz> | 2022-07-11 10:56:48 +0900 |
| commit | ec5f1fe2fca5f7b8f06aed6f3f4efbe8288c031e (patch) | |
| tree | 47f71465539901ed66dc203f7024429f68ff9608 | |
| parent | ab7fef0acfbd33331b4d3a000d501454fdcee8f2 (diff) | |
| download | postgresql-ec5f1fe2fca5f7b8f06aed6f3f4efbe8288c031e.tar.gz postgresql-ec5f1fe2fca5f7b8f06aed6f3f4efbe8288c031e.zip | |
doc: Fix inconsistent quotes in some jsonb fields
Single quotes are not allowed in json internals, double quotes are.
Reported-by: Eric Mutta
Discussion: https://postgr.es/m/165715362165.665.3875113264927503997@wrigleys.postgresql.org
Backpatch-through: 14
| -rw-r--r-- | doc/src/sgml/json.sgml | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/doc/src/sgml/json.sgml b/doc/src/sgml/json.sgml index a173368229b..c421d4ba75a 100644 --- a/doc/src/sgml/json.sgml +++ b/doc/src/sgml/json.sgml @@ -701,10 +701,10 @@ UPDATE table_name SET jsonb_field[2] = '2'; assigned value can be placed. <programlisting> --- Where jsonb_field was {}, it is now {'a': [{'b': 1}]} +-- Where jsonb_field was {}, it is now {"a": [{"b": 1}]} UPDATE table_name SET jsonb_field['a'][0]['b'] = '1'; --- Where jsonb_field was [], it is now [null, {'a': 1}] +-- Where jsonb_field was [], it is now [null, {"a": 1}] UPDATE table_name SET jsonb_field[1]['a'] = '1'; </programlisting> |