RosettaCodeData/Task/Array-concatenation/DuckDB/array-concatenation.duckdb

5 lines
195 B
Plaintext

# Concatenate two JSON arrays to produce an instance of JSON[]
create or replace function jsonarray2list(j) as (
select list_transform(range(0, json_array_length(j)::BIGINT), i -> (j -> i))
);