No response
select array[1]::int[] || array[1.2]::numeric[];
select 1::int || array[1.2]::numeric[];
select array[1.2]::numeric[] || 1::int;
Should successfully concatenate the two arrays.
https://github.com/risingwavelabs/risingwave/pull/5060#discussion_r961402491
PR is merged and issue is finished. Thank you very much for you help @xiangjinwu