regress/expected/json.out

1343 select * from json_populate_record(null::jpop,'{"a":"blurfl","x":43.2}') q;
1349 select * from json_populate_record(row('x',3,'2012-12-31 15:30:56')::jpop,'{"a":"blurfl","x":43.2}'…
1355 select * from json_populate_record(null::jpop,'{"a":"blurfl","x":43.2}') q;
1361 select * from json_populate_record(row('x',3,'2012-12-31 15:30:56')::jpop,'{"a":"blurfl","x":43.2}'…
1367 select * from json_populate_record(null::jpop,'{"a":[100,200,false],"x":43.2}') q;
1373 select * from json_populate_record(row('x',3,'2012-12-31 15:30:56')::jpop,'{"a":[100,200,false],"x"…
1379 select * from json_populate_record(row('x',3,'2012-12-31 15:30:56')::jpop,'{"c":[100,200,false],"x"…
1381 select * from json_populate_record(row('x',3,'2012-12-31 15:30:56')::jpop,'{}') q;
1387 SELECT i FROM json_populate_record(NULL::jsrec_i_not_null, '{"x": 43.2}') q;
1389 SELECT i FROM json_populate_record(NULL::jsrec_i_not_null, '{"i": null}') q;
1391 SELECT i FROM json_populate_record(NULL::jsrec_i_not_null, '{"i": 12345}') q;
1397 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": null}') q;
1403 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": 123}') q;
1406 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": [1, "2", null, 4]}') q;
1412 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": [[1, 2], [3, 4]]}') q;
1418 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": [[1], 2]}') q;
1421 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": [[1], [2, 3]]}') q;
1424 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": "{1,2,3}"}') q;
1430 SELECT ia1 FROM json_populate_record(NULL::jsrec, '{"ia1": null}') q;
1436 SELECT ia1 FROM json_populate_record(NULL::jsrec, '{"ia1": 123}') q;
1439 SELECT ia1 FROM json_populate_record(NULL::jsrec, '{"ia1": [1, "2", null, 4]}') q;
1445 SELECT ia1 FROM json_populate_record(NULL::jsrec, '{"ia1": [[1, 2, 3]]}') q;
1451 SELECT ia1d FROM json_populate_record(NULL::jsrec, '{"ia1d": null}') q;
1457 SELECT ia1d FROM json_populate_record(NULL::jsrec, '{"ia1d": 123}') q;
1460 SELECT ia1d FROM json_populate_record(NULL::jsrec, '{"ia1d": [1, "2", null, 4]}') q;
1462 SELECT ia1d FROM json_populate_record(NULL::jsrec, '{"ia1d": [1, "2", null]}') q;
1468 SELECT ia2 FROM json_populate_record(NULL::jsrec, '{"ia2": [1, "2", null, 4]}') q;
1474 SELECT ia2 FROM json_populate_record(NULL::jsrec, '{"ia2": [[1, 2], [null, 4]]}') q;
1480 SELECT ia2 FROM json_populate_record(NULL::jsrec, '{"ia2": [[], []]}') q;
1486 SELECT ia2 FROM json_populate_record(NULL::jsrec, '{"ia2": [[1, 2], [3]]}') q;
1489 SELECT ia2 FROM json_populate_record(NULL::jsrec, '{"ia2": [[1, 2], 3, 4]}') q;
1492 SELECT ia2d FROM json_populate_record(NULL::jsrec, '{"ia2d": [[1, "2"], [null, 4]]}') q;
1494 SELECT ia2d FROM json_populate_record(NULL::jsrec, '{"ia2d": [[1, "2", 3], [null, 5, 6]]}') q;
1500 SELECT ia3 FROM json_populate_record(NULL::jsrec, '{"ia3": [1, "2", null, 4]}') q;
1506 SELECT ia3 FROM json_populate_record(NULL::jsrec, '{"ia3": [[1, 2], [null, 4]]}') q;
1512 SELECT ia3 FROM json_populate_record(NULL::jsrec, '{"ia3": [ [[], []], [[], []], [[], []] ]}') q;
1518 SELECT ia3 FROM json_populate_record(NULL::jsrec, '{"ia3": [ [[1, 2]], [[3, 4]] ]}') q;
1524 SELECT ia3 FROM json_populate_record(NULL::jsrec, '{"ia3": [ [[1, 2], [3, 4]], [[5, 6], [7, 8]] ]}'…
1530 SELECT ia3 FROM json_populate_record(NULL::jsrec, '{"ia3": [ [[1, 2], [3, 4]], [[5, 6], [7, 8], [9,…
1533 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": null}') q;
1539 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": 123}') q;
1542 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": [1, "2", null, 4]}') q;
1548 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": [[1, 2, 3], {"k": "v"}]}') q;
1551 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": null}') q;
1557 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": "aaa"}') q;
1563 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": "aaaaaaaaaa"}') q;
1569 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": "aaaaaaaaaaaaa"}') q;
1571 SELECT ca FROM json_populate_record(NULL::jsrec, '{"ca": null}') q;
1577 SELECT ca FROM json_populate_record(NULL::jsrec, '{"ca": 123}') q;
1580 SELECT ca FROM json_populate_record(NULL::jsrec, '{"ca": [1, "2", null, 4]}') q;
1586 SELECT ca FROM json_populate_record(NULL::jsrec, '{"ca": ["aaaaaaaaaaaaaaaa"]}') q;
1588 SELECT ca FROM json_populate_record(NULL::jsrec, '{"ca": [[1, 2, 3], {"k": "v"}]}') q;
1591 SELECT js FROM json_populate_record(NULL::jsrec, '{"js": null}') q;
1597 SELECT js FROM json_populate_record(NULL::jsrec, '{"js": true}') q;
1603 SELECT js FROM json_populate_record(NULL::jsrec, '{"js": 123.45}') q;
1609 SELECT js FROM json_populate_record(NULL::jsrec, '{"js": "123.45"}') q;
1615 SELECT js FROM json_populate_record(NULL::jsrec, '{"js": "abc"}') q;
1621 SELECT js FROM json_populate_record(NULL::jsrec, '{"js": [123, "123", null, {"key": "value"}]}') q;
1627 SELECT js FROM json_populate_record(NULL::jsrec, '{"js": {"a": "bbb", "b": null, "c": 123.45}}') q;
1633 SELECT jsb FROM json_populate_record(NULL::jsrec, '{"jsb": null}') q;
1639 SELECT jsb FROM json_populate_record(NULL::jsrec, '{"jsb": true}') q;
1645 SELECT jsb FROM json_populate_record(NULL::jsrec, '{"jsb": 123.45}') q;
1651 SELECT jsb FROM json_populate_record(NULL::jsrec, '{"jsb": "123.45"}') q;
1657 SELECT jsb FROM json_populate_record(NULL::jsrec, '{"jsb": "abc"}') q;
1663 SELECT jsb FROM json_populate_record(NULL::jsrec, '{"jsb": [123, "123", null, {"key": "value"}]}') …
1669 SELECT jsb FROM json_populate_record(NULL::jsrec, '{"jsb": {"a": "bbb", "b": null, "c": 123.45}}') …
1675 SELECT jsa FROM json_populate_record(NULL::jsrec, '{"jsa": null}') q;
1681 SELECT jsa FROM json_populate_record(NULL::jsrec, '{"jsa": 123}') q;
1684 SELECT jsa FROM json_populate_record(NULL::jsrec, '{"jsa": [1, "2", null, 4]}') q;
1690 SELECT jsa FROM json_populate_record(NULL::jsrec, '{"jsa": ["aaa", null, [1, 2, "3", {}], { "k" : "…
1696 SELECT rec FROM json_populate_record(NULL::jsrec, '{"rec": 123}') q;
1698 SELECT rec FROM json_populate_record(NULL::jsrec, '{"rec": [1, 2]}') q;
1700 SELECT rec FROM json_populate_record(NULL::jsrec, '{"rec": {"a": "abc", "c": "01.02.2003", "x": 43.…
1706 SELECT rec FROM json_populate_record(NULL::jsrec, '{"rec": "(abc,42,01.02.2003)"}') q;
1712 SELECT reca FROM json_populate_record(NULL::jsrec, '{"reca": 123}') q;
1715 SELECT reca FROM json_populate_record(NULL::jsrec, '{"reca": [1, 2]}') q;
1717 SELECT reca FROM json_populate_record(NULL::jsrec, '{"reca": [{"a": "abc", "b": 456}, null, {"c": "…
1723 SELECT reca FROM json_populate_record(NULL::jsrec, '{"reca": ["(abc,42,01.02.2003)"]}') q;
1729 SELECT reca FROM json_populate_record(NULL::jsrec, '{"reca": "{\"(abc,42,01.02.2003)\"}"}') q;
1735 SELECT rec FROM json_populate_record(
1746 SELECT json_populate_record(null::record, '{"x": 0, "y": 1}');
1747 ERROR:  could not determine row type for result of json_populate_record
1749 SELECT json_populate_record(row(1,2), '{"f1": 0, "f2": 1}');
1750  json_populate_record
1756   json_populate_record(null::record, '{"x": 776}') AS (x int, y int);
1763 SELECT json_populate_record(null::j_ordered_pair, '{"x": 0, "y": 1}');
1764  json_populate_record
1769 SELECT json_populate_record(row(1,2)::j_ordered_pair, '{"x": 0}');
1770  json_populate_record
1775 SELECT json_populate_record(row(1,2)::j_ordered_pair, '{"x": 1, "y": 0}');
1919 -- test type info caching in json_populate_record()
1928 SELECT (json_populate_record(NULL::jsrec, js)).* FROM jspoptest;