Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit1cd1821

Browse files
committed
doc: Fix inconsistent quotes in some jsonb fields
Single quotes are not allowed in json internals, double quotes are.Reported-by: Eric MuttaDiscussion:https://postgr.es/m/165715362165.665.3875113264927503997@wrigleys.postgresql.orgBackpatch-through: 14
1 parent92d70b7 commit1cd1821

File tree

1 file changed

+2
-2
lines changed

1 file changed

+2
-2
lines changed

‎doc/src/sgml/json.sgml

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -701,10 +701,10 @@ UPDATE table_name SET jsonb_field[2] = '2';
701701
assigned value can be placed.
702702

703703
<programlisting>
704-
-- Where jsonb_field was {}, it is now {'a': [{'b': 1}]}
704+
-- Where jsonb_field was {}, it is now {"a": [{"b": 1}]}
705705
UPDATE table_name SET jsonb_field['a'][0]['b'] = '1';
706706

707-
-- Where jsonb_field was [], it is now [null, {'a': 1}]
707+
-- Where jsonb_field was [], it is now [null, {"a": 1}]
708708
UPDATE table_name SET jsonb_field[1]['a'] = '1';
709709
</programlisting>
710710

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp