[GENERAL] text array accumulate to multidimensional text array

[Rainer Zaiss]

Dear list,

I would like to aggregate a text array into a multidimensional text array.

Let us say I have one table with two collumns

ID    ARRAY
A    {"A1","B1","C1"}
A    {"A2","B2","C2"}
B     {"A3","B3","C3"}

If I use a GROUP BY ID, I would like to receive following result:

ID  ARRAY
A  {{"A1","B1","C1"},{"A2","B2","C2"}}
B  {{"A3","B3","C3"}}

I searched around but I didn't find any solution

Thank you for your help

Rainer