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  ("Merlin Moncure" <mmoncure@gmail.com>)
Resp.: text array accumulate to multidimensional text array  ("Osvaldo Kussama" <osvaldo.kussama@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Glen Brown"
Дата:
Сообщение: Slow to delete TOAST table data
Следующее
От: Eric Haszlakiewicz
Дата:
Сообщение: Re: Re: BUG #4078: ERROR: operator does not exist: numeric = character varying