| /dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/ |
| H A D | jsonb.sql | 659 select * from jsonb_to_record('{"a":1,"b":"foo","c":"bar"}')
673 select * from jsonb_to_record('{"ia": null}') as x(ia _int4);
674 select * from jsonb_to_record('{"ia": 123}') as x(ia _int4);
677 select * from jsonb_to_record('{"ia": [[1], 2]}') as x(ia _int4);
678 select * from jsonb_to_record('{"ia": [[1], [2, 3]]}') as x(ia _int4);
680 select * from jsonb_to_record('{"ia2": [1, 2, 3]}') as x(ia2 int[][]);
684 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out json);
685 select * from jsonb_to_record('{"out": [{"key": 1}]}') as x(out json);
686 select * from jsonb_to_record('{"out": "{\"key\": 1}"}') as x(out json);
687 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out jsonb);
[all …]
|
| /dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/ |
| H A D | jsonb.sql | 659 select * from jsonb_to_record('{"a":1,"b":"foo","c":"bar"}')
673 select * from jsonb_to_record('{"ia": null}') as x(ia _int4);
674 select * from jsonb_to_record('{"ia": 123}') as x(ia _int4);
677 select * from jsonb_to_record('{"ia": [[1], 2]}') as x(ia _int4);
678 select * from jsonb_to_record('{"ia": [[1], [2, 3]]}') as x(ia _int4);
680 select * from jsonb_to_record('{"ia2": [1, 2, 3]}') as x(ia2 int[][]);
684 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out json);
685 select * from jsonb_to_record('{"out": [{"key": 1}]}') as x(out json);
686 select * from jsonb_to_record('{"out": "{\"key\": 1}"}') as x(out json);
687 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out jsonb);
[all …]
|
| /dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/ |
| H A D | jsonb.sql | 659 select * from jsonb_to_record('{"a":1,"b":"foo","c":"bar"}')
673 select * from jsonb_to_record('{"ia": null}') as x(ia _int4);
674 select * from jsonb_to_record('{"ia": 123}') as x(ia _int4);
677 select * from jsonb_to_record('{"ia": [[1], 2]}') as x(ia _int4);
678 select * from jsonb_to_record('{"ia": [[1], [2, 3]]}') as x(ia _int4);
680 select * from jsonb_to_record('{"ia2": [1, 2, 3]}') as x(ia2 int[][]);
684 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out json);
685 select * from jsonb_to_record('{"out": [{"key": 1}]}') as x(out json);
686 select * from jsonb_to_record('{"out": "{\"key\": 1}"}') as x(out json);
687 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out jsonb);
[all …]
|
| /dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/ |
| H A D | jsonb.sql | 659 select * from jsonb_to_record('{"a":1,"b":"foo","c":"bar"}')
673 select * from jsonb_to_record('{"ia": null}') as x(ia _int4);
674 select * from jsonb_to_record('{"ia": 123}') as x(ia _int4);
677 select * from jsonb_to_record('{"ia": [[1], 2]}') as x(ia _int4);
678 select * from jsonb_to_record('{"ia": [[1], [2, 3]]}') as x(ia _int4);
680 select * from jsonb_to_record('{"ia2": [1, 2, 3]}') as x(ia2 int[][]);
684 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out json);
685 select * from jsonb_to_record('{"out": [{"key": 1}]}') as x(out json);
686 select * from jsonb_to_record('{"out": "{\"key\": 1}"}') as x(out json);
687 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out jsonb);
[all …]
|
| /dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/ |
| H A D | jsonb.sql | 659 select * from jsonb_to_record('{"a":1,"b":"foo","c":"bar"}')
673 select * from jsonb_to_record('{"ia": null}') as x(ia _int4);
674 select * from jsonb_to_record('{"ia": 123}') as x(ia _int4);
677 select * from jsonb_to_record('{"ia": [[1], 2]}') as x(ia _int4);
678 select * from jsonb_to_record('{"ia": [[1], [2, 3]]}') as x(ia _int4);
680 select * from jsonb_to_record('{"ia2": [1, 2, 3]}') as x(ia2 int[][]);
684 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out json);
685 select * from jsonb_to_record('{"out": [{"key": 1}]}') as x(out json);
686 select * from jsonb_to_record('{"out": "{\"key\": 1}"}') as x(out json);
687 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out jsonb);
[all …]
|
| /dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/sql/ |
| H A D | jsonb.sql | 659 select * from jsonb_to_record('{"a":1,"b":"foo","c":"bar"}')
673 select * from jsonb_to_record('{"ia": null}') as x(ia _int4);
674 select * from jsonb_to_record('{"ia": 123}') as x(ia _int4);
677 select * from jsonb_to_record('{"ia": [[1], 2]}') as x(ia _int4);
678 select * from jsonb_to_record('{"ia": [[1], [2, 3]]}') as x(ia _int4);
680 select * from jsonb_to_record('{"ia2": [1, 2, 3]}') as x(ia2 int[][]);
684 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out json);
685 select * from jsonb_to_record('{"out": [{"key": 1}]}') as x(out json);
686 select * from jsonb_to_record('{"out": "{\"key\": 1}"}') as x(out json);
687 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out jsonb);
[all …]
|
| /dports/databases/postgresql10-server/postgresql-10.19/src/test/regress/sql/ |
| H A D | jsonb.sql | 659 select * from jsonb_to_record('{"a":1,"b":"foo","c":"bar"}')
673 select * from jsonb_to_record('{"ia": null}') as x(ia _int4);
674 select * from jsonb_to_record('{"ia": 123}') as x(ia _int4);
677 select * from jsonb_to_record('{"ia": [[1], 2]}') as x(ia _int4);
678 select * from jsonb_to_record('{"ia": [[1], [2, 3]]}') as x(ia _int4);
680 select * from jsonb_to_record('{"ia2": [1, 2, 3]}') as x(ia2 int[][]);
684 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out json);
685 select * from jsonb_to_record('{"out": [{"key": 1}]}') as x(out json);
686 select * from jsonb_to_record('{"out": "{\"key\": 1}"}') as x(out json);
687 select * from jsonb_to_record('{"out": {"key": 1}}') as x(out jsonb);
[all …]
|
| /dports/databases/postgresql11-contrib/postgresql-11.14/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/postgresql11-docs/postgresql-11.14/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/postgresql11-client/postgresql-11.14/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/postgresql11-plperl/postgresql-11.14/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/postgresql11-server/postgresql-11.14/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/postgresql11-pltcl/postgresql-11.14/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/postgresql11-plpython/postgresql-11.14/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/postgresql12-client/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-pltcl/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-plpython/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-server/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-contrib/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/postgresql12-server/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-client/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/postgresql12-plperl/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/postgresql12-docs/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/postgresql12-plpython/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/postgresql12-contrib/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 …]
|