/dports/databases/postgresql13-contrib/postgresql-13.5/src/test/regress/sql/ |
H A D | json.sql | 438 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": null}') q; 439 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": 123}') q; 473 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": 123}') q; 477 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": null}') q; 478 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": "aaa"}') q; 483 SELECT ca FROM json_populate_record(NULL::jsrec, '{"ca": 123}') q; 520 SELECT rec FROM json_populate_record( 527 SELECT json_populate_record(null::record, '{"x": 0, "y": 1}'); 528 SELECT json_populate_record(row(1,2), '{"f1": 0, "f2": 1}'); 534 SELECT json_populate_record(row(1,2)::j_ordered_pair, '{"x": 0}'); [all …]
|
/dports/databases/postgresql12-server/postgresql-12.9/src/test/regress/sql/ |
H A D | json.sql | 434 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": null}') q; 435 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": 123}') q; 469 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": 123}') q; 473 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": null}') q; 474 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": "aaa"}') q; 479 SELECT ca FROM json_populate_record(NULL::jsrec, '{"ca": 123}') q; 516 SELECT rec FROM json_populate_record( 523 SELECT json_populate_record(null::record, '{"x": 0, "y": 1}'); 524 SELECT json_populate_record(row(1,2), '{"f1": 0, "f2": 1}'); 530 SELECT json_populate_record(row(1,2)::j_ordered_pair, '{"x": 0}'); [all …]
|
/dports/databases/postgresql13-client/postgresql-13.5/src/test/regress/sql/ |
H A D | json.sql | 438 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": null}') q; 439 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": 123}') q; 473 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": 123}') q; 477 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": null}') q; 478 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": "aaa"}') q; 483 SELECT ca FROM json_populate_record(NULL::jsrec, '{"ca": 123}') q; 520 SELECT rec FROM json_populate_record( 527 SELECT json_populate_record(null::record, '{"x": 0, "y": 1}'); 528 SELECT json_populate_record(row(1,2), '{"f1": 0, "f2": 1}'); 534 SELECT json_populate_record(row(1,2)::j_ordered_pair, '{"x": 0}'); [all …]
|
/dports/databases/postgresql12-plperl/postgresql-12.9/src/test/regress/sql/ |
H A D | json.sql | 434 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": null}') q; 435 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": 123}') q; 469 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": 123}') q; 473 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": null}') q; 474 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": "aaa"}') q; 479 SELECT ca FROM json_populate_record(NULL::jsrec, '{"ca": 123}') q; 516 SELECT rec FROM json_populate_record( 523 SELECT json_populate_record(null::record, '{"x": 0, "y": 1}'); 524 SELECT json_populate_record(row(1,2), '{"f1": 0, "f2": 1}'); 530 SELECT json_populate_record(row(1,2)::j_ordered_pair, '{"x": 0}'); [all …]
|
/dports/databases/postgresql12-docs/postgresql-12.9/src/test/regress/sql/ |
H A D | json.sql | 434 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": null}') q; 435 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": 123}') q; 469 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": 123}') q; 473 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": null}') q; 474 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": "aaa"}') q; 479 SELECT ca FROM json_populate_record(NULL::jsrec, '{"ca": 123}') q; 516 SELECT rec FROM json_populate_record( 523 SELECT json_populate_record(null::record, '{"x": 0, "y": 1}'); 524 SELECT json_populate_record(row(1,2), '{"f1": 0, "f2": 1}'); 530 SELECT json_populate_record(row(1,2)::j_ordered_pair, '{"x": 0}'); [all …]
|
/dports/databases/postgresql12-plpython/postgresql-12.9/src/test/regress/sql/ |
H A D | json.sql | 434 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": null}') q; 435 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": 123}') q; 469 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": 123}') q; 473 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": null}') q; 474 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": "aaa"}') q; 479 SELECT ca FROM json_populate_record(NULL::jsrec, '{"ca": 123}') q; 516 SELECT rec FROM json_populate_record( 523 SELECT json_populate_record(null::record, '{"x": 0, "y": 1}'); 524 SELECT json_populate_record(row(1,2), '{"f1": 0, "f2": 1}'); 530 SELECT json_populate_record(row(1,2)::j_ordered_pair, '{"x": 0}'); [all …]
|
/dports/databases/postgresql12-contrib/postgresql-12.9/src/test/regress/sql/ |
H A D | json.sql | 434 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": null}') q; 435 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": 123}') q; 469 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": 123}') q; 473 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": null}') q; 474 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": "aaa"}') q; 479 SELECT ca FROM json_populate_record(NULL::jsrec, '{"ca": 123}') q; 516 SELECT rec FROM json_populate_record( 523 SELECT json_populate_record(null::record, '{"x": 0, "y": 1}'); 524 SELECT json_populate_record(row(1,2), '{"f1": 0, "f2": 1}'); 530 SELECT json_populate_record(row(1,2)::j_ordered_pair, '{"x": 0}'); [all …]
|
/dports/databases/postgresql12-pltcl/postgresql-12.9/src/test/regress/sql/ |
H A D | json.sql | 434 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": null}') q; 435 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": 123}') q; 469 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": 123}') q; 473 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": null}') q; 474 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": "aaa"}') q; 479 SELECT ca FROM json_populate_record(NULL::jsrec, '{"ca": 123}') q; 516 SELECT rec FROM json_populate_record( 523 SELECT json_populate_record(null::record, '{"x": 0, "y": 1}'); 524 SELECT json_populate_record(row(1,2), '{"f1": 0, "f2": 1}'); 530 SELECT json_populate_record(row(1,2)::j_ordered_pair, '{"x": 0}'); [all …]
|
/dports/databases/postgresql13-plperl/postgresql-13.5/src/test/regress/sql/ |
H A D | json.sql | 438 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": null}') q; 439 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": 123}') q; 473 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": 123}') q; 477 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": null}') q; 478 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": "aaa"}') q; 483 SELECT ca FROM json_populate_record(NULL::jsrec, '{"ca": 123}') q; 520 SELECT rec FROM json_populate_record( 527 SELECT json_populate_record(null::record, '{"x": 0, "y": 1}'); 528 SELECT json_populate_record(row(1,2), '{"f1": 0, "f2": 1}'); 534 SELECT json_populate_record(row(1,2)::j_ordered_pair, '{"x": 0}'); [all …]
|
/dports/databases/postgresql13-docs/postgresql-13.5/src/test/regress/sql/ |
H A D | json.sql | 438 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": null}') q; 439 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": 123}') q; 473 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": 123}') q; 477 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": null}') q; 478 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": "aaa"}') q; 483 SELECT ca FROM json_populate_record(NULL::jsrec, '{"ca": 123}') q; 520 SELECT rec FROM json_populate_record( 527 SELECT json_populate_record(null::record, '{"x": 0, "y": 1}'); 528 SELECT json_populate_record(row(1,2), '{"f1": 0, "f2": 1}'); 534 SELECT json_populate_record(row(1,2)::j_ordered_pair, '{"x": 0}'); [all …]
|
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/ |
H A D | json.sql | 954 json_populate_record(NULL::jsrec, '{"ia": null}') q; 959 json_populate_record(NULL::jsrec, '{"ia": 123}') q; 994 json_populate_record(NULL::jsrec, '{"ia1": 123}') q; 1094 json_populate_record(NULL::jsrec, '{"ta": null}') q; 1099 json_populate_record(NULL::jsrec, '{"ta": 123}') q; 1114 json_populate_record(NULL::jsrec, '{"c": null}') q; 1119 json_populate_record(NULL::jsrec, '{"c": "aaa"}') q; 1134 json_populate_record(NULL::jsrec, '{"ca": null}') q; 1139 json_populate_record(NULL::jsrec, '{"ca": 123}') q; 1159 json_populate_record(NULL::jsrec, '{"js": null}') q; [all …]
|
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/ |
H A D | json.sql | 434 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": null}') q; 435 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": 123}') q; 469 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": 123}') q; 473 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": null}') q; 474 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": "aaa"}') q; 479 SELECT ca FROM json_populate_record(NULL::jsrec, '{"ca": 123}') q; 516 SELECT rec FROM json_populate_record( 523 SELECT json_populate_record(null::record, '{"x": 0, "y": 1}'); 524 SELECT json_populate_record(row(1,2), '{"f1": 0, "f2": 1}'); 528 SELECT json_populate_record(row(1,2)::j_ordered_pair, '{"x": 0}'); [all …]
|
/dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/expected/ |
H A D | json.out | 1403 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": 123}') q; 1539 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": 123}') q; 1551 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": null}') q; 1735 SELECT rec FROM json_populate_record( 1746 SELECT json_populate_record(null::record, '{"x": 0, "y": 1}'); 1749 SELECT json_populate_record(row(1,2), '{"f1": 0, "f2": 1}'); 1750 json_populate_record 1764 json_populate_record 1770 json_populate_record 1919 -- test type info caching in json_populate_record() [all …]
|
/dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/expected/ |
H A D | json.out | 1403 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": 123}') q; 1539 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": 123}') q; 1551 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": null}') q; 1735 SELECT rec FROM json_populate_record( 1746 SELECT json_populate_record(null::record, '{"x": 0, "y": 1}'); 1749 SELECT json_populate_record(row(1,2), '{"f1": 0, "f2": 1}'); 1750 json_populate_record 1764 json_populate_record 1770 json_populate_record 1919 -- test type info caching in json_populate_record() [all …]
|
/dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/expected/ |
H A D | json.out | 1403 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": 123}') q; 1539 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": 123}') q; 1551 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": null}') q; 1735 SELECT rec FROM json_populate_record( 1746 SELECT json_populate_record(null::record, '{"x": 0, "y": 1}'); 1749 SELECT json_populate_record(row(1,2), '{"f1": 0, "f2": 1}'); 1750 json_populate_record 1764 json_populate_record 1770 json_populate_record 1919 -- test type info caching in json_populate_record() [all …]
|
/dports/databases/postgresql11-server/postgresql-11.14/src/test/regress/expected/ |
H A D | json.out | 1403 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": 123}') q; 1539 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": 123}') q; 1551 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": null}') q; 1735 SELECT rec FROM json_populate_record( 1746 SELECT json_populate_record(null::record, '{"x": 0, "y": 1}'); 1749 SELECT json_populate_record(row(1,2), '{"f1": 0, "f2": 1}'); 1750 json_populate_record 1764 json_populate_record 1770 json_populate_record 1919 -- test type info caching in json_populate_record() [all …]
|
/dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/expected/ |
H A D | json.out | 1403 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": 123}') q; 1539 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": 123}') q; 1551 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": null}') q; 1735 SELECT rec FROM json_populate_record( 1746 SELECT json_populate_record(null::record, '{"x": 0, "y": 1}'); 1749 SELECT json_populate_record(row(1,2), '{"f1": 0, "f2": 1}'); 1750 json_populate_record 1764 json_populate_record 1770 json_populate_record 1919 -- test type info caching in json_populate_record() [all …]
|
/dports/databases/postgresql11-plpython/postgresql-11.14/src/test/regress/expected/ |
H A D | json.out | 1403 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": 123}') q; 1539 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": 123}') q; 1551 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": null}') q; 1735 SELECT rec FROM json_populate_record( 1746 SELECT json_populate_record(null::record, '{"x": 0, "y": 1}'); 1749 SELECT json_populate_record(row(1,2), '{"f1": 0, "f2": 1}'); 1750 json_populate_record 1764 json_populate_record 1770 json_populate_record 1919 -- test type info caching in json_populate_record() [all …]
|
/dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/regress/expected/ |
H A D | json.out | 1403 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": 123}') q; 1539 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": 123}') q; 1551 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": null}') q; 1735 SELECT rec FROM json_populate_record( 1746 SELECT json_populate_record(null::record, '{"x": 0, "y": 1}'); 1749 SELECT json_populate_record(row(1,2), '{"f1": 0, "f2": 1}'); 1750 json_populate_record 1764 json_populate_record 1770 json_populate_record 1919 -- test type info caching in json_populate_record() [all …]
|
/dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/expected/ |
H A D | json.out | 1403 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": 123}') q; 1539 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": 123}') q; 1551 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": null}') q; 1735 SELECT rec FROM json_populate_record( 1746 SELECT json_populate_record(null::record, '{"x": 0, "y": 1}'); 1749 SELECT json_populate_record(row(1,2), '{"f1": 0, "f2": 1}'); 1750 json_populate_record 1764 json_populate_record 1770 json_populate_record 1919 -- test type info caching in json_populate_record() [all …]
|
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/expected/ |
H A D | json.out | 1442 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": 123}') q; 1578 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": 123}') q; 1590 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": null}') q; 1774 SELECT rec FROM json_populate_record( 1785 SELECT json_populate_record(null::record, '{"x": 0, "y": 1}'); 1788 SELECT json_populate_record(row(1,2), '{"f1": 0, "f2": 1}'); 1789 json_populate_record 1803 json_populate_record 1809 json_populate_record 1958 -- test type info caching in json_populate_record() [all …]
|
/dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/expected/ |
H A D | json.out | 1442 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": 123}') q; 1578 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": 123}') q; 1590 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": null}') q; 1774 SELECT rec FROM json_populate_record( 1785 SELECT json_populate_record(null::record, '{"x": 0, "y": 1}'); 1788 SELECT json_populate_record(row(1,2), '{"f1": 0, "f2": 1}'); 1789 json_populate_record 1803 json_populate_record 1809 json_populate_record 1958 -- test type info caching in json_populate_record() [all …]
|
/dports/databases/postgresql14-docs/postgresql-14.1/src/test/regress/expected/ |
H A D | json.out | 1442 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": 123}') q; 1578 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": 123}') q; 1590 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": null}') q; 1774 SELECT rec FROM json_populate_record( 1785 SELECT json_populate_record(null::record, '{"x": 0, "y": 1}'); 1788 SELECT json_populate_record(row(1,2), '{"f1": 0, "f2": 1}'); 1789 json_populate_record 1803 json_populate_record 1809 json_populate_record 1958 -- test type info caching in json_populate_record() [all …]
|
/dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/expected/ |
H A D | json.out | 1442 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": 123}') q; 1578 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": 123}') q; 1590 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": null}') q; 1774 SELECT rec FROM json_populate_record( 1785 SELECT json_populate_record(null::record, '{"x": 0, "y": 1}'); 1788 SELECT json_populate_record(row(1,2), '{"f1": 0, "f2": 1}'); 1789 json_populate_record 1803 json_populate_record 1809 json_populate_record 1958 -- test type info caching in json_populate_record() [all …]
|
/dports/databases/postgresql14-plpython/postgresql-14.1/src/test/regress/expected/ |
H A D | json.out | 1442 SELECT ia FROM json_populate_record(NULL::jsrec, '{"ia": 123}') q; 1578 SELECT ta FROM json_populate_record(NULL::jsrec, '{"ta": 123}') q; 1590 SELECT c FROM json_populate_record(NULL::jsrec, '{"c": null}') q; 1774 SELECT rec FROM json_populate_record( 1785 SELECT json_populate_record(null::record, '{"x": 0, "y": 1}'); 1788 SELECT json_populate_record(row(1,2), '{"f1": 0, "f2": 1}'); 1789 json_populate_record 1803 json_populate_record 1809 json_populate_record 1958 -- test type info caching in json_populate_record() [all …]
|