Lines Matching refs:jsonb_to_record
697 select * from jsonb_to_record('{"a":1,"b":"foo","c":"bar"}')
704 from jsonb_to_record('{"a":1, "b":{"c":16, "d":2}, "x":8, "ca": ["1 2", 3], "ia": [[1,2],[3,4]], "r…
711 select * from jsonb_to_record('{"ia": null}') as x(ia _int4);
712 select * from jsonb_to_record('{"ia": 123}') as x(ia _int4);
713 select * from jsonb_to_record('{"ia": [1, "2", null, 4]}') as x(ia _int4);
714 select * from jsonb_to_record('{"ia": [[1, 2], [3, 4]]}') as x(ia _int4);
715 select * from jsonb_to_record('{"ia": [[1], 2]}') as x(ia _int4);
716 select * from jsonb_to_record('{"ia": [[1], [2, 3]]}') as x(ia _int4);
718 select * from jsonb_to_record('{"ia2": [1, 2, 3]}') as x(ia2 int[][]);
719 select * from jsonb_to_record('{"ia2": [[1, 2], [3, 4]]}') as x(ia2 int4[][]);
720 select * from jsonb_to_record('{"ia2": [[[1], [2], [3]]]}') as x(ia2 int4[][]);
722 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out json);
723 select * from jsonb_to_record('{"out": [{"key": 1}]}') as x(out json);
724 select * from jsonb_to_record('{"out": "{\"key\": 1}"}') as x(out json);
725 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out jsonb);
726 select * from jsonb_to_record('{"out": [{"key": 1}]}') as x(out jsonb);
727 select * from jsonb_to_record('{"out": "{\"key\": 1}"}') as x(out jsonb);