postgres.git / summary / log / commit / refs

commit    ec5f1fe2fca5f7b8f06aed6f3f4efbe8288c031e
Author:   Michael Paquier <michael@paquier.xyz>
Date:     Mon Jul 11 01:56:48 2022 +0000

    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


 doc/src/sgml/json.sgml | 4 ++--
 1 file 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>
 


[parent: ab7fef0acfbd]