Commits

Andrew Dunstan committed 2ef6e8a

additional test

Comments (0)

Files changed (2)

src/test/regress/expected/json.out

  false
 (6 rows)
 
+select * from json_unnest('[1,true,[1,[2,3]],null,{"f1":1,"f2":[7,8,9]},false]') q;
+         value         
+-----------------------
+ 1
+ true
+ [1,[2,3]]
+ null
+ {"f1":1,"f2":[7,8,9]}
+ false
+(6 rows)
+

src/test/regress/sql/json.sql

 --unnest
 
 select json_unnest('[1,true,[1,[2,3]],null,{"f1":1,"f2":[7,8,9]},false]');
+select * from json_unnest('[1,true,[1,[2,3]],null,{"f1":1,"f2":[7,8,9]},false]') q;