jsonb_populate_record_valid ( base anyelement, from_json json ) → boolean
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.
select jsonb_populate_record_valid(NULL::jsb_char2, '{"a": "aaa"}'); → jsonb_populate_record_valid
-----------------------------
f
(1 row)
select * from jsonb_populate_record(NULL::jsb_char2, '{"a": "aaa"}') q; → ERROR: value too long for type character(2)
select jsonb_populate_record_valid(NULL::jsb_char2, '{"a": "aa"}'); → jsonb_populate_record_valid
-----------------------------
t
(1 row)
select * from jsonb_populate_record(NULL::jsb_char2, '{"a": "aa"}') q; → a
----
aa
(1 row)