text array accumulate to multidimensional text array

Поиск
Список
Период
Сортировка
От Rainer Zaiss
Тема text array accumulate to multidimensional text array
Дата
Msg-id 7B20CDA1F68841C8A01EA5CDA363C153@geographer
обсуждение исходный текст
Ответы Re: text array accumulate to multidimensional text array
Resp.: text array accumulate to multidimensional text array
Список pgsql-general
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
 

В списке pgsql-general по дате отправления: