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