| /dports/databases/postgresql12-pltcl/postgresql-12.9/src/test/regress/sql/ |
| H A D | jsonb.sql | 693 select * from jsonb_to_record('{"a":1,"b":"foo","c":"bar"}')
707 select * from jsonb_to_record('{"ia": null}') as x(ia _int4);
708 select * from jsonb_to_record('{"ia": 123}') 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[][]);
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);
[all …]
|
| /dports/databases/postgresql13-plperl/postgresql-13.5/src/test/regress/sql/ |
| H A D | jsonb.sql | 697 select * from jsonb_to_record('{"a":1,"b":"foo","c":"bar"}')
711 select * from jsonb_to_record('{"ia": null}') as x(ia _int4);
712 select * from jsonb_to_record('{"ia": 123}') 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[][]);
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);
[all …]
|
| /dports/databases/postgresql13-docs/postgresql-13.5/src/test/regress/sql/ |
| H A D | jsonb.sql | 697 select * from jsonb_to_record('{"a":1,"b":"foo","c":"bar"}')
711 select * from jsonb_to_record('{"ia": null}') as x(ia _int4);
712 select * from jsonb_to_record('{"ia": 123}') 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[][]);
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);
[all …]
|
| /dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/ |
| H A D | jsonb.sql | 714 select * from jsonb_to_record('{"a":1,"b":"foo","c":"bar"}')
728 select * from jsonb_to_record('{"ia": null}') as x(ia _int4);
729 select * from jsonb_to_record('{"ia": 123}') as x(ia _int4);
732 select * from jsonb_to_record('{"ia": [[1], 2]}') as x(ia _int4);
733 select * from jsonb_to_record('{"ia": [[1], [2, 3]]}') as x(ia _int4);
735 select * from jsonb_to_record('{"ia2": [1, 2, 3]}') as x(ia2 int[][]);
739 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out json);
740 select * from jsonb_to_record('{"out": [{"key": 1}]}') as x(out json);
741 select * from jsonb_to_record('{"out": "{\"key\": 1}"}') as x(out json);
742 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out jsonb);
[all …]
|
| /dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/sql/ |
| H A D | jsonb.sql | 714 select * from jsonb_to_record('{"a":1,"b":"foo","c":"bar"}')
728 select * from jsonb_to_record('{"ia": null}') as x(ia _int4);
729 select * from jsonb_to_record('{"ia": 123}') as x(ia _int4);
732 select * from jsonb_to_record('{"ia": [[1], 2]}') as x(ia _int4);
733 select * from jsonb_to_record('{"ia": [[1], [2, 3]]}') as x(ia _int4);
735 select * from jsonb_to_record('{"ia2": [1, 2, 3]}') as x(ia2 int[][]);
739 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out json);
740 select * from jsonb_to_record('{"out": [{"key": 1}]}') as x(out json);
741 select * from jsonb_to_record('{"out": "{\"key\": 1}"}') as x(out json);
742 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out jsonb);
[all …]
|
| /dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/sql/ |
| H A D | jsonb.sql | 714 select * from jsonb_to_record('{"a":1,"b":"foo","c":"bar"}')
728 select * from jsonb_to_record('{"ia": null}') as x(ia _int4);
729 select * from jsonb_to_record('{"ia": 123}') as x(ia _int4);
732 select * from jsonb_to_record('{"ia": [[1], 2]}') as x(ia _int4);
733 select * from jsonb_to_record('{"ia": [[1], [2, 3]]}') as x(ia _int4);
735 select * from jsonb_to_record('{"ia2": [1, 2, 3]}') as x(ia2 int[][]);
739 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out json);
740 select * from jsonb_to_record('{"out": [{"key": 1}]}') as x(out json);
741 select * from jsonb_to_record('{"out": "{\"key\": 1}"}') as x(out json);
742 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out jsonb);
[all …]
|
| /dports/databases/postgresql14-plpython/postgresql-14.1/src/test/regress/sql/ |
| H A D | jsonb.sql | 714 select * from jsonb_to_record('{"a":1,"b":"foo","c":"bar"}')
728 select * from jsonb_to_record('{"ia": null}') as x(ia _int4);
729 select * from jsonb_to_record('{"ia": 123}') as x(ia _int4);
732 select * from jsonb_to_record('{"ia": [[1], 2]}') as x(ia _int4);
733 select * from jsonb_to_record('{"ia": [[1], [2, 3]]}') as x(ia _int4);
735 select * from jsonb_to_record('{"ia2": [1, 2, 3]}') as x(ia2 int[][]);
739 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out json);
740 select * from jsonb_to_record('{"out": [{"key": 1}]}') as x(out json);
741 select * from jsonb_to_record('{"out": "{\"key\": 1}"}') as x(out json);
742 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out jsonb);
[all …]
|
| /dports/databases/postgresql14-docs/postgresql-14.1/src/test/regress/sql/ |
| H A D | jsonb.sql | 714 select * from jsonb_to_record('{"a":1,"b":"foo","c":"bar"}')
728 select * from jsonb_to_record('{"ia": null}') as x(ia _int4);
729 select * from jsonb_to_record('{"ia": 123}') as x(ia _int4);
732 select * from jsonb_to_record('{"ia": [[1], 2]}') as x(ia _int4);
733 select * from jsonb_to_record('{"ia": [[1], [2, 3]]}') as x(ia _int4);
735 select * from jsonb_to_record('{"ia2": [1, 2, 3]}') as x(ia2 int[][]);
739 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out json);
740 select * from jsonb_to_record('{"out": [{"key": 1}]}') as x(out json);
741 select * from jsonb_to_record('{"out": "{\"key\": 1}"}') as x(out json);
742 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out jsonb);
[all …]
|
| /dports/databases/postgresql14-contrib/postgresql-14.1/src/test/regress/sql/ |
| H A D | jsonb.sql | 714 select * from jsonb_to_record('{"a":1,"b":"foo","c":"bar"}')
728 select * from jsonb_to_record('{"ia": null}') as x(ia _int4);
729 select * from jsonb_to_record('{"ia": 123}') as x(ia _int4);
732 select * from jsonb_to_record('{"ia": [[1], 2]}') as x(ia _int4);
733 select * from jsonb_to_record('{"ia": [[1], [2, 3]]}') as x(ia _int4);
735 select * from jsonb_to_record('{"ia2": [1, 2, 3]}') as x(ia2 int[][]);
739 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out json);
740 select * from jsonb_to_record('{"out": [{"key": 1}]}') as x(out json);
741 select * from jsonb_to_record('{"out": "{\"key\": 1}"}') as x(out json);
742 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out jsonb);
[all …]
|
| /dports/databases/postgresql14-client/postgresql-14.1/src/test/regress/sql/ |
| H A D | jsonb.sql | 714 select * from jsonb_to_record('{"a":1,"b":"foo","c":"bar"}')
728 select * from jsonb_to_record('{"ia": null}') as x(ia _int4);
729 select * from jsonb_to_record('{"ia": 123}') as x(ia _int4);
732 select * from jsonb_to_record('{"ia": [[1], 2]}') as x(ia _int4);
733 select * from jsonb_to_record('{"ia": [[1], [2, 3]]}') as x(ia _int4);
735 select * from jsonb_to_record('{"ia2": [1, 2, 3]}') as x(ia2 int[][]);
739 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out json);
740 select * from jsonb_to_record('{"out": [{"key": 1}]}') as x(out json);
741 select * from jsonb_to_record('{"out": "{\"key\": 1}"}') as x(out json);
742 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out jsonb);
[all …]
|
| /dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/ |
| H A D | jsonb.sql | 687 select * from jsonb_to_record('{"a":1,"b":"foo","c":"bar"}')
694 from jsonb_to_record('{"a":1, "b":{"c":16, "d":2}, "x":8, "ca": ["1 2", 3], "ia": [[1,2],[3,4]], "r…
701 select * from jsonb_to_record('{"ia": null}') as x(ia _int4);
702 select * from jsonb_to_record('{"ia": 123}') as x(ia _int4);
703 select * from jsonb_to_record('{"ia": [1, "2", null, 4]}') as x(ia _int4);
704 select * from jsonb_to_record('{"ia": [[1, 2], [3, 4]]}') as x(ia _int4);
705 select * from jsonb_to_record('{"ia": [[1], 2]}') as x(ia _int4);
706 select * from jsonb_to_record('{"ia": [[1], [2, 3]]}') as x(ia _int4);
708 select * from jsonb_to_record('{"ia2": [1, 2, 3]}') as x(ia2 int[][]);
709 select * from jsonb_to_record('{"ia2": [[1, 2], [3, 4]]}') as x(ia2 int4[][]);
[all …]
|
| /dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/ |
| H A D | jsonb.sql | 1877 jsonb_to_record('{"a":1,"b":"foo","c":"bar"}') AS x (a int,
1892 …jsonb_to_record('{"a":1, "b":{"c":16, "d":2}, "x":8, "ca": ["1 2", 3], "ia": [[1,2],[3,4]], "r": {…
1912 jsonb_to_record('{"ia": null}') AS x (ia _int4);
1917 jsonb_to_record('{"ia": 123}') AS x (ia _int4);
1922 jsonb_to_record('{"ia": [1, "2", null, 4]}') AS x (ia _int4);
1927 jsonb_to_record('{"ia": [[1, 2], [3, 4]]}') AS x (ia _int4);
1932 jsonb_to_record('{"ia": [[1], 2]}') AS x (ia _int4);
1937 jsonb_to_record('{"ia": [[1], [2, 3]]}') AS x (ia _int4);
1942 jsonb_to_record('{"ia2": [1, 2, 3]}') AS x (ia2 int[][]);
1947 jsonb_to_record('{"ia2": [[1, 2], [3, 4]]}') AS x (ia2 int4[][]);
[all …]
|
| /dports/databases/postgresql96-server/postgresql-9.6.24/src/include/utils/ |
| H A D | json.h | 82 extern Datum jsonb_to_record(PG_FUNCTION_ARGS);
|
| /dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/include/utils/ |
| H A D | json.h | 82 extern Datum jsonb_to_record(PG_FUNCTION_ARGS);
|
| /dports/databases/postgresql96-plpython/postgresql-9.6.24/src/include/utils/ |
| H A D | json.h | 82 extern Datum jsonb_to_record(PG_FUNCTION_ARGS);
|
| /dports/databases/postgresql96-plperl/postgresql-9.6.24/src/include/utils/ |
| H A D | json.h | 82 extern Datum jsonb_to_record(PG_FUNCTION_ARGS);
|
| /dports/databases/postgresql96-docs/postgresql-9.6.24/src/include/utils/ |
| H A D | json.h | 82 extern Datum jsonb_to_record(PG_FUNCTION_ARGS);
|
| /dports/databases/postgresql96-client/postgresql-9.6.24/src/include/utils/ |
| H A D | json.h | 82 extern Datum jsonb_to_record(PG_FUNCTION_ARGS);
|
| /dports/databases/postgresql96-contrib/postgresql-9.6.24/src/include/utils/ |
| H A D | json.h | 82 extern Datum jsonb_to_record(PG_FUNCTION_ARGS);
|
| /dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/expected/ |
| H A D | jsonb.out | 2504 -- jsonb_to_record and jsonb_to_recordset
2505 select * from jsonb_to_record('{"a":1,"b":"foo","c":"bar"}')
2536 select * from jsonb_to_record('{"ia": null}') as x(ia _int4);
2542 select * from jsonb_to_record('{"ia": 123}') as x(ia _int4);
2557 select * from jsonb_to_record('{"ia": [[1], 2]}') as x(ia _int4);
2560 select * from jsonb_to_record('{"ia": [[1], [2, 3]]}') as x(ia _int4);
2563 select * from jsonb_to_record('{"ia2": [1, 2, 3]}') as x(ia2 int[][]);
2581 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out json);
2587 select * from jsonb_to_record('{"out": [{"key": 1}]}') as x(out json);
2599 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out jsonb);
[all …]
|
| /dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/expected/ |
| H A D | jsonb.out | 2504 -- jsonb_to_record and jsonb_to_recordset
2505 select * from jsonb_to_record('{"a":1,"b":"foo","c":"bar"}')
2536 select * from jsonb_to_record('{"ia": null}') as x(ia _int4);
2542 select * from jsonb_to_record('{"ia": 123}') as x(ia _int4);
2557 select * from jsonb_to_record('{"ia": [[1], 2]}') as x(ia _int4);
2560 select * from jsonb_to_record('{"ia": [[1], [2, 3]]}') as x(ia _int4);
2563 select * from jsonb_to_record('{"ia2": [1, 2, 3]}') as x(ia2 int[][]);
2581 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out json);
2587 select * from jsonb_to_record('{"out": [{"key": 1}]}') as x(out json);
2599 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out jsonb);
[all …]
|
| /dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/expected/ |
| H A D | jsonb.out | 2504 -- jsonb_to_record and jsonb_to_recordset
2505 select * from jsonb_to_record('{"a":1,"b":"foo","c":"bar"}')
2536 select * from jsonb_to_record('{"ia": null}') as x(ia _int4);
2542 select * from jsonb_to_record('{"ia": 123}') as x(ia _int4);
2557 select * from jsonb_to_record('{"ia": [[1], 2]}') as x(ia _int4);
2560 select * from jsonb_to_record('{"ia": [[1], [2, 3]]}') as x(ia _int4);
2563 select * from jsonb_to_record('{"ia2": [1, 2, 3]}') as x(ia2 int[][]);
2581 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out json);
2587 select * from jsonb_to_record('{"out": [{"key": 1}]}') as x(out json);
2599 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out jsonb);
[all …]
|
| /dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/expected/ |
| H A D | jsonb.out | 2504 -- jsonb_to_record and jsonb_to_recordset
2505 select * from jsonb_to_record('{"a":1,"b":"foo","c":"bar"}')
2536 select * from jsonb_to_record('{"ia": null}') as x(ia _int4);
2542 select * from jsonb_to_record('{"ia": 123}') as x(ia _int4);
2557 select * from jsonb_to_record('{"ia": [[1], 2]}') as x(ia _int4);
2560 select * from jsonb_to_record('{"ia": [[1], [2, 3]]}') as x(ia _int4);
2563 select * from jsonb_to_record('{"ia2": [1, 2, 3]}') as x(ia2 int[][]);
2581 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out json);
2587 select * from jsonb_to_record('{"out": [{"key": 1}]}') as x(out json);
2599 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out jsonb);
[all …]
|
| /dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/expected/ |
| H A D | jsonb.out | 2504 -- jsonb_to_record and jsonb_to_recordset
2505 select * from jsonb_to_record('{"a":1,"b":"foo","c":"bar"}')
2536 select * from jsonb_to_record('{"ia": null}') as x(ia _int4);
2542 select * from jsonb_to_record('{"ia": 123}') as x(ia _int4);
2557 select * from jsonb_to_record('{"ia": [[1], 2]}') as x(ia _int4);
2560 select * from jsonb_to_record('{"ia": [[1], [2, 3]]}') as x(ia _int4);
2563 select * from jsonb_to_record('{"ia2": [1, 2, 3]}') as x(ia2 int[][]);
2581 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out json);
2587 select * from jsonb_to_record('{"out": [{"key": 1}]}') as x(out json);
2599 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out jsonb);
[all …]
|
| /dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/expected/ |
| H A D | jsonb.out | 2504 -- jsonb_to_record and jsonb_to_recordset
2505 select * from jsonb_to_record('{"a":1,"b":"foo","c":"bar"}')
2536 select * from jsonb_to_record('{"ia": null}') as x(ia _int4);
2542 select * from jsonb_to_record('{"ia": 123}') as x(ia _int4);
2557 select * from jsonb_to_record('{"ia": [[1], 2]}') as x(ia _int4);
2560 select * from jsonb_to_record('{"ia": [[1], [2, 3]]}') as x(ia _int4);
2563 select * from jsonb_to_record('{"ia2": [1, 2, 3]}') as x(ia2 int[][]);
2581 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out json);
2587 select * from jsonb_to_record('{"out": [{"key": 1}]}') as x(out json);
2599 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out jsonb);
[all …]
|