/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 …]
|