Postgres Pro
Downloads
Home   >   mailing lists

text array accumulate to multidimensional text array - Mailing list pgsql-general

From Rainer Zaiss
Subject text array accumulate to multidimensional text array
Date
Msg-id 7B20CDA1F68841C8A01EA5CDA363C153@geographer
Whole thread Raw
Responses 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>)
List pgsql-general
Tree view
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 by date:

Previous
From: "Glen Brown"
Date:
Subject: Slow to delete TOAST table data
Next
From: Eric Haszlakiewicz
Date:
Subject: Re: Re: BUG #4078: ERROR: operator does not exist: numeric = character varying