-TEST=# SELECT '{"a": 1, "b": 2, "c": 3}'::jsonb || '{"a": 4, "b": 2, "d": 4}'::jsonb;
- ?column?
-----------------------------------
- {"a": 4, "b": 2, "c": 3, "d": 4}
-(1 row)
-
-TEST=# SELECT '["a", "b"]'::jsonb || '["c"]'::jsonb;
- ?column?
------------------
- ["a", "b", "c"]
-(1 row)
-
-TEST=# SELECT '[1,2,3]'::jsonb || '[3,4,5]'::jsonb;
- ?column?
---------------------
- [1, 2, 3, 3, 4, 5]
-(1 row)
-
-TEST=# SELECT '{"a": 1, "b": 2, "c": 3}'::jsonb || '[1,2,3]'::jsonb;
- ?column?
--------------------------------------
- [{"a": 1, "b": 2, "c": 3}, 1, 2, 3]
-(1 row)
-
-TEST=# SELECT '{"a": 1, "b": 2, "c": 3}'::jsonb || '[1,2,3]'::jsonb || '"a"'::jsonb;
- ?column?
-------------------------------------------
- [{"a": 1, "b": 2, "c": 3}, 1, 2, 3, "a"]
-(1 row)