text array accumulate to multidimensional text array

["Rainer Zaiss" <r.zaiss@xxxxxxx>]

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