regress/sql/json.sql

385 create type jpop as (a text, b int, c timestamp);
407 	rec	jpop,
408 	reca	jpop[]
415 select * from json_populate_record(null::jpop,'{"a":"blurfl","x":43.2}') q;
416 select * from json_populate_record(row('x',3,'2012-12-31 15:30:56')::jpop,'{"a":"blurfl","x":43.2}'…
418 select * from json_populate_record(null::jpop,'{"a":"blurfl","x":43.2}') q;
419 select * from json_populate_record(row('x',3,'2012-12-31 15:30:56')::jpop,'{"a":"blurfl","x":43.2}'…
421 select * from json_populate_record(null::jpop,'{"a":[100,200,false],"x":43.2}') q;
422 select * from json_populate_record(row('x',3,'2012-12-31 15:30:56')::jpop,'{"a":[100,200,false],"x"…
423 select * from json_populate_record(row('x',3,'2012-12-31 15:30:56')::jpop,'{"c":[100,200,false],"x"…
425 select * from json_populate_record(row('x',3,'2012-12-31 15:30:56')::jpop,'{}') q;
515 		row('x',3,'2012-12-31 15:30:56')::jpop,NULL)::jsrec,
521 select * from json_populate_recordset(null::jpop,'[{"a":"blurfl","x":43.2},{"b":3,"c":"2012-01-20 1…
522 select * from json_populate_recordset(row('def',99,null)::jpop,'[{"a":"blurfl","x":43.2},{"b":3,"c"…
523 select * from json_populate_recordset(null::jpop,'[{"a":"blurfl","x":43.2},{"b":3,"c":"2012-01-20 1…
524 select * from json_populate_recordset(row('def',99,null)::jpop,'[{"a":"blurfl","x":43.2},{"b":3,"c"…
525 select * from json_populate_recordset(row('def',99,null)::jpop,'[{"a":[100,200,300],"x":43.2},{"a":…
526 select * from json_populate_recordset(row('def',99,null)::jpop,'[{"c":[100,200,300],"x":43.2},{"a":…
531 select * from json_populate_recordset(null::jpop,'[{"a":"blurfl","x":43.2},{"b":3,"c":"2012-01-20 1…
532 select * from json_populate_recordset(row('def',99,null)::jpop,'[{"a":"blurfl","x":43.2},{"b":3,"c"…
533 select * from json_populate_recordset(row('def',99,null)::jpop,'[{"a":[100,200,300],"x":43.2},{"a":…
698     as t(a int, b json, c text, x int, ca char(5)[], ia int[][], r jpop);