risingwave_expr_impl::scalar::jsonb_concat

Function jsonb_concat

Source 
pub fn jsonb_concat(left: JsonbRef<'_>, right: JsonbRef<'_>) -> JsonbVal
Expand description

Concatenates the two jsonbs.

Examples:

# concat
query T
SELECT '[1,2]'::jsonb || '[3,4]'::jsonb;
----
[1, 2, 3, 4]

query T
SELECT '{"a": 1}'::jsonb || '{"b": 2}'::jsonb;
----
{"a": 1, "b": 2}

query T
SELECT '[1,2]'::jsonb || '{"a": 1}'::jsonb;
----
[1, 2, {"a": 1}]

query T
SELECT '1'::jsonb || '2'::jsonb;
----
[1, 2]

query T
SELECT '[1,2]'::jsonb || 'null'::jsonb;
----
[1, 2, null]

query T
SELECT 'null'::jsonb || '[1,2]'::jsonb;
----
[null, 1, 2]

query T
SELECT 'null'::jsonb || '1'::jsonb;
----
[null, 1]