You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
<
8000
script type="application/json" data-target="react-app.embeddedData">{"payload":{"commit":{"oid":"b2b6c1be0569548893a80f15c74084243fb8d8a1","url":"/postgres/postgres/commit/b2b6c1be0569548893a80f15c74084243fb8d8a1","authoredDate":"2022-07-11T10:56:42.000+09:00","committedDate":"2022-07-11T10:56:42.000+09:00","shortMessage":null,"shortMessageMarkdown":"\u003cdiv\u003edoc: Fix inconsistent quotes in some jsonb fields\u003c/div\u003e","shortMessageMarkdownLink":null,"bodyMessageHtml":"Single quotes are not allowed in json internals, double quotes are.\n\nReported-by: Eric Mutta\nDiscussion: \u003ca href=\"https://postgr.es/m/165715362165.665.3875113264927503997@wrigleys.postgresql.org\" rel=\"nofollow\"\u003ehttps://postgr.es/m/165715362165.665.3875113264927503997@wrigleys.postgresql.org\u003c/a\u003e\nBackpatch-through: 14","authors":[{"login":"michaelpq","displayName":"Michael Paquier","avatarUrl":"https://avatars.githubusercontent.com/u/985332?v=4","path":"/michaelpq","isGitHub":false}],"committerAttribution":false,"committer":{"login":"michaelpq","displayName":"Michael Paquier","avatarUrl":"https://avatars.githubusercontent.com/u/985332?v=4","path":"/michaelpq","isGitHub":false},"parents":["31b485f883a7db27319d4ea8a724151c21db7bb8"],"globalRelayId":"C_kwDOAA4m0toAKGIyYjZjMWJlMDU2OTU0ODg5M2E4MGYxNWM3NDA4NDI0M2ZiOGQ4YTE","sha1":"31b485f883a7db27319d4ea8a724151c21db7bb8","sha2":"b2b6c1be0569548893a80f15c74084243fb8d8a1"},"currentUser":null,"repo":{"id":927442,"defaultBranch":"master","name":"postgres","ownerLogin":"postgres","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2010-09-21T11:35:45.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/177543?v=4","public":true,"private":false,"isOrgOwned":true},"diffEntryData":[{"diffLines":[{"stylingDirective":null,"type":"HUNK","blobLineNumber":700,"text":"@@ -701,10 +701,10 @@ UPDATE table_name SET jsonb_field[2] = '2';","html":"@@ -701,10 +701,10 @@ UPDATE table_name SET jsonb_field[2] = \u0026#39;2\u0026#39;;","displayNoNewLineWarning":false,"position":0,"left":700,"right":700},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":701,"text":" assigned value can be placed.","html":" assigned value can be placed.","displayNoNewLineWarning":false,"position":1,"left":701,"right":701},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":702,"text":" ","html":"\u003cbr\u003e","displayNoNewLineWarning":false,"position":2,"left":702,"right":702},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":703,"text":" \u003cprogramlisting\u003e","html":" \u0026lt;programlisting\u0026gt;","displayNoNewLineWarning":false,"position":3,"left":703,"right":703},{"stylingDirective":null,"type":"DELETION","blobLineNumber":704,"text":"--- Where jsonb_field was {}, it is now {'a': [{'b': 1}]}","html":"--- Where jsonb_field was {}, it is now {\u003cspan class=\"x x-first x-last\"\u003e\u0026#39;a\u0026#39;\u003c/span\u003e: [{\u003cspan class=\"x x-first x-last\"\u003e\u0026#39;b\u0026#39;\u003c/span\u003e: 1}]}","displayNoNewLineWarning":false,"position":4,"left":704,"right":703},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":704,"text":"+-- Where jsonb_field was {}, it is now {\"a\": [{\"b\": 1}]}","html":"+-- Where jsonb_field was {}, it is now {\u003cspan class=\"x x-first x-last\"\u003e\u0026quot;a\u0026quot;\u003c/span\u003e: [{\u003cspan class=\"x x-first x-last\"\u003e\u0026quot;b\u0026quot;\u003c/span\u003e: 1}]}","displayNoNewLineWarning":false,"position":5,"left":704,"right":704},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":705,"text":" UPDATE table_name SET jsonb_field['a'][0]['b'] = '1';","html":" UPDATE table_name SET jsonb_field[\u0026#39;a\u0026#39;][0][\u0026#39;b\u0026#39;] = \u0026#39;1\u0026#39;;","displayNoNewLineWarning":false,"position":6,"left":705,"right":705},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":706,"text":" ","html":"\u003cbr\u003e","displayNoNewLineWarning":false,"position":7,"left":706,"right":706},{"stylingDirective":null,"type":"DELETION","blobLineNumber":707,"text":"--- Where jsonb_field was [], it is now [null, {'a': 1}]","html":"--- Where jsonb_field was [], it is now [null, {\u003cspan class=\"x x-first x-last\"\u003e\u0026#39;a\u0026#39;\u003c/span\u003e: 1}]","displayNoNewLineWarning":false,"position":8,"left":707,"right":706},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":707,"text":"+-- Where jsonb_field was [], it is now [null, {\"a\": 1}]","html":"+-- Where jsonb_field was [], it is now [null, {\u003cspan class=\"x x-first x-last\"\u003e\u0026quot;a\u0026quot;\u003c/span\u003e: 1}]","displayNoNewLineWarning":false,"position":9,"left":707,"right":707},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":708,"text":" UPDATE table_name SET jsonb_field[1]['a'] = '1';","html":" UPDATE table_name SET jsonb_field[1][\u0026#39;a\u0026#39;] = \u0026#39;1\u0026#39;;","displayNoNewLineWarning":false,"position":10,"left":708,"right":708},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":709,"text":" \u003c/programlisting\u003e","html":" \u0026lt;/programlisting\u0026gt;","displayNoNewLineWarning":false,"position":11,"left":709,"right":709},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":710,"text":" ","html":"\u003cbr\u003e","displayNoNewLineWarning":false,"position":12,"left":710,"right":710}],"diffNumber":0,"diffSize":"0 Bytes","isBinary":false,"isTooBig":false,"collapsed":false,"isSubmodule":false,"lineCount":1013,"linesChanged":4,"newTreeEntry":{"lineCount":1013,"path":"doc/src/sgml/json.sgml","mode":100644,"isGenerated":false},"oldTreeEntry":{"lineCount":0,"path":"doc/src/sgml/json.sgml","mode":100644},"linesAdded":2,"linesDeleted":2,"path":"doc/src/sgml/json.sgml","pathDigest":"a1452d233d25b17ac9ba86626595c60bb2a79350c256960535cfe6fe7857806b","status":"MODIFIED","truncatedReason":null,"oldOid":"31b485f883a7db27319d4ea8a724151c21db7bb8","newOid":"b2b6c1be0569548893a80f15c74084243fb8d8a1","copilotChatReference":null,"deletedSha":"31b485f883a7db27319d4ea8a724151c21db7bb8","canToggleRichDiff":false,"defaultToRichDiff":false,"proseDifffHtml":null,"renderInfo":null,"dependencyDiffPath":null,"submodule":null}],"splitViewPreference":"unified","ignoreWhitespace":false,"repoOwnerGlobalRelayId":"MDEyOk9yZ2FuaXphdGlvbjE3NzU0Mw==","commentsPreference":"visible","diffLineSpacingPreference":"relaxed","useMonospaceFont":false,"pasteUrlLinkAsPlainText":false,"userNotices":[],"path":"/postgres/postgres/commit/b2b6c1be0569548893a80f15c74084243fb8d8a1","fileTreeExpanded":true,"headerInfo":{"additions":2,"deletions":2,"filesChanged":1,"filesChangedString":"1"},"moreDiffsToLoad":false,"asyncDiffLoadInfo":{"startIndex":1,"truncated":false,"byteCount":477,"lineShownCount":13},"commentInfo":{"canComment":false,"locked":false,"canLock":false,"repoArchived":false},"csrf_tokens":{"/users/diffview?diff=split":{"post":"uLmy2x89DIgQyhA0BWg6PVU4RtTGJKdF14joH7BALiTOPBnFRk_rfW8iOV_L_OQDYcQifJbBc-UgEMw5PEedCg"},"/users/diffview?diff=unified":{"post":"eJm6mFUOpQrakhOH3Tmro34ootBa31xFOUdQv9p6RZUOHBGGDHxC_6V6OuwTrXWdStTGeAo6iOXO33SZVn32uw"},"/notifications/thread":{"post":"BzU5oHIxuAy7HigSLOF107cdTJJy307vo031sgJ87LjYMU9yr5TtU-jIGH43AFF7kGlbvBMvxT9uew-4GxtURg"}}},"title":"doc: Fix inconsistent quotes in some jsonb fields · postgres/postgres@b2b6c1b","appPayload":{"helpUrl":"https://docs.github.com","findInDiffWorkerPath":"/assets-cdn/worker/find-in-diff-worker-2bfe39677d14.js","enabled_features":{"diff_ux_refresh_beta":false,"diff_inline_comments":true,"diff_ux_refresh_ssr_five":false,"diff_ux_refresh_ssr_ten":false,"react_diff_line_type_character_correction":true}}}
0 commit comments