{"Entry":{"collection":"func","key":"jsonb-populate-record-valid","name":"jsonb_populate_record_valid","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"16","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"17"}],"content_hash":"a52a2372093999c345747c98d359a67535641152dc1d857456072bd4b60b678e","first_version":"17","group":"json","group_label":"Json Functions And Operators","groups":["json"],"imported_at":"2026-09-14T21:49:48.811964+08:00","last_version":"20","name":"jsonb_populate_record_valid","name_key":"jsonb_populate_record_valid","position":16049,"present_in":["17","18","19","20"],"signature":"jsonb_populate_record_valid ( base anyelement, from_json json ) → boolean","signature_count":1,"slug":"jsonb-populate-record-valid","source_rev":"2026-09-14T13:14:25.684213+00:00@99e6866c","summary":"Function for testing jsonb_populate_record.","summary_zh":""}},"Definition":{"Collection":"func","Key":"jsonb-populate-record-valid","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"jsonb-populate-record-valid","SourceRevision":"2026-09-14T13:14:25.684213+00:00@99e6866c","Facts":{"description":"Function for testing jsonb_populate_record. Returns true if the input jsonb_populate_record would finish without an error for the given input JSON object; that is, it's valid input, false otherwise.","description_html":"Function for testing \u003ccode class=\"function\"\u003ejsonb_populate_record\u003c/code\u003e. Returns \u003ccode class=\"literal\"\u003etrue\u003c/code\u003e if the input \u003ccode class=\"function\"\u003ejsonb_populate_record\u003c/code\u003e would finish without an error for the given input JSON object; that is, it's valid input, \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e otherwise.","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-JSON-PROCESSING-TABLE","file":"functions-json.html","slug":"18"},"group":"json","group_label":"Json Functions And Operators","lang":"en","layout":"table-new","pages":["functions-json.html"],"prose_only":false,"signatures":[{"description":"Function for testing jsonb_populate_record. Returns true if the input jsonb_populate_record would finish without an error for the given input JSON object; that is, it's valid input, false otherwise.","description_html":"Function for testing \u003ccode class=\"function\"\u003ejsonb_populate_record\u003c/code\u003e. Returns \u003ccode class=\"literal\"\u003etrue\u003c/code\u003e if the input \u003ccode class=\"function\"\u003ejsonb_populate_record\u003c/code\u003e would finish without an error for the given input JSON object; that is, it's valid input, \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e otherwise.","description_zh":"","description_zh_html":"","examples":[{"expr":"select jsonb_populate_record_valid(NULL::jsb_char2, '{\"a\": \"aaa\"}');","result":" jsonb_populate_record_valid\n-----------------------------\n f\n(1 row)"},{"expr":"select * from jsonb_populate_record(NULL::jsb_char2, '{\"a\": \"aaa\"}') q;","result":"ERROR:  value too long for type character(2)"},{"expr":"select jsonb_populate_record_valid(NULL::jsb_char2, '{\"a\": \"aa\"}');","result":" jsonb_populate_record_valid\n-----------------------------\n t\n(1 row)"},{"expr":"select * from jsonb_populate_record(NULL::jsb_char2, '{\"a\": \"aa\"}') q;","result":" a\n----\n aa\n(1 row)"}],"html":"\u003ccode class=\"function\"\u003ejsonb_populate_record_valid\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003ebase\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eanyelement\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003efrom_json\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ejson\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003eboolean\u003c/code\u003e","returns":"boolean","text":"jsonb_populate_record_valid ( base anyelement, from_json json ) → boolean","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-JSON-PROCESSING-TABLE","file":"functions-json.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"jsonb-populate-record-valid","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"jsonb_populate_record_valid","Summary":"用于测试jsonb_populate_record的函数。对于给定的输入 JSON 对象，如果jsonb_populate_record能够无错误地完成，即该输入有效，则返回true；否则返回false。","BodyHTML":"用于测试\u003ccode\u003ejsonb_populate_record\u003c/code\u003e的函数。对于给定的输入 JSON 对象，如果\u003ccode\u003ejsonb_populate_record\u003c/code\u003e能够无错误地完成，即该输入有效，则返回\u003ccode\u003etrue\u003c/code\u003e；否则返回\u003ccode\u003efalse\u003c/code\u003e。\u003cpre\u003ejsonb_populate_record_valid ( base anyelement, from_json json ) → boolean\u003c/pre\u003e用于测试\u003ccode\u003ejsonb_populate_record\u003c/code\u003e的函数。对于给定的输入 JSON 对象，如果\u003ccode\u003ejsonb_populate_record\u003c/code\u003e能够无错误地完成，即该输入有效，则返回\u003ccode\u003etrue\u003c/code\u003e；否则返回\u003ccode\u003efalse\u003c/code\u003e。","SourceRevision":"ca936764","ContentHash":"f6c5277372febeedbfb6740e65b1b75e85a03219e1e0cc8cac7079c3d672b406","Payload":{"description_zh":"用于测试jsonb_populate_record的函数。对于给定的输入 JSON 对象，如果jsonb_populate_record能够无错误地完成，即该输入有效，则返回true；否则返回false。","description_zh_html":"用于测试\u003ccode class=\"function\"\u003ejsonb_populate_record\u003c/code\u003e的函数。对于给定的输入 JSON 对象，如果\u003ccode class=\"function\"\u003ejsonb_populate_record\u003c/code\u003e能够无错误地完成，即该输入有效，则返回\u003ccode class=\"literal\"\u003etrue\u003c/code\u003e；否则返回\u003ccode class=\"literal\"\u003efalse\u003c/code\u003e。","signatures":[{"description_zh":"用于测试jsonb_populate_record的函数。对于给定的输入 JSON 对象，如果jsonb_populate_record能够无错误地完成，即该输入有效，则返回true；否则返回false。","description_zh_html":"用于测试\u003ccode class=\"function\"\u003ejsonb_populate_record\u003c/code\u003e的函数。对于给定的输入 JSON 对象，如果\u003ccode class=\"function\"\u003ejsonb_populate_record\u003c/code\u003e能够无错误地完成，即该输入有效，则返回\u003ccode class=\"literal\"\u003etrue\u003c/code\u003e；否则返回\u003ccode class=\"literal\"\u003efalse\u003c/code\u003e。","returns":"boolean","text":"jsonb_populate_record_valid ( base anyelement, from_json json ) → boolean","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"dfcf93de1134e693d5209f23fbf4edf33fe997ad3725cf407455889cd88a3402","Text":"jsonb_populate_record_valid ( base anyelement, from_json json ) → boolean","Returns":"boolean","Payload":{"description":"Function for testing jsonb_populate_record. Returns true if the input jsonb_populate_record would finish without an error for the given input JSON object; that is, it's valid input, false otherwise.","description_html":"Function for testing \u003ccode class=\"function\"\u003ejsonb_populate_record\u003c/code\u003e. Returns \u003ccode class=\"literal\"\u003etrue\u003c/code\u003e if the input \u003ccode class=\"function\"\u003ejsonb_populate_record\u003c/code\u003e would finish without an error for the given input JSON object; that is, it's valid input, \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e otherwise.","description_zh":"","description_zh_html":"","examples":[{"expr":"select jsonb_populate_record_valid(NULL::jsb_char2, '{\"a\": \"aaa\"}');","result":" jsonb_populate_record_valid\n-----------------------------\n f\n(1 row)"},{"expr":"select * from jsonb_populate_record(NULL::jsb_char2, '{\"a\": \"aaa\"}') q;","result":"ERROR:  value too long for type character(2)"},{"expr":"select jsonb_populate_record_valid(NULL::jsb_char2, '{\"a\": \"aa\"}');","result":" jsonb_populate_record_valid\n-----------------------------\n t\n(1 row)"},{"expr":"select * from jsonb_populate_record(NULL::jsb_char2, '{\"a\": \"aa\"}') q;","result":" a\n----\n aa\n(1 row)"}],"html":"\u003ccode class=\"function\"\u003ejsonb_populate_record_valid\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003ebase\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eanyelement\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003efrom_json\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ejson\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003eboolean\u003c/code\u003e","returns":"boolean","text":"jsonb_populate_record_valid ( base anyelement, from_json json ) → boolean","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}