postgresql 实现将数组变为行

SELECT "unnest"(array[1,2,3])

结果：
unnest

SELECT "unnest"(array[1,2,3]) INTERSECT SELECT "unnest"(array[3,4,5]) 

结果：
unnest
3

select id,string_agg(name,',') AS NAME_NEW from test
group by 1
ORDER BY 1

select id,array_agg(name)
AS NAME_NEW from test
group by 1
ORDER BY 1;

select id,array_to_string(array_agg(name),',')
AS NAME_NEW from test
group by 1
ORDER BY 1;

select id,regexp_split_to_table(name_new,',')
AS NAME from test;

select id,unnest(string_to_array(name_new,','))
AS NAME from test;