Re: [GENERAL] Horizontal aggregation?

2012-04-14 Thread hamann . w
>> >> >> >> Hi, >> >> >> >> I am looking for a feature that would select from a table with >> >> >> >> If such an operator exists, would there be a "remove duplicates" option? >> >> >> >> Regards >> >> Wolfgang Hamann >> >> >> > >> > select k, array_agg(distinct val ) from t; >> > >> > See the do

Re: [GENERAL] Horizontal aggregation?

2012-04-13 Thread Abel Abraham Camarillo Ojeda
On Sat, Apr 14, 2012 at 1:28 AM, Abel Abraham Camarillo Ojeda wrote: > On Sat, Apr 14, 2012 at 1:22 AM,   wrote: >> >> >> Hi, >> >> I am looking for a feature that would select from a table with >> k1  a >> k1  b >> k1  c >> k2  a >> k3  b >> k3  c >> something like >> k1  a b c >> k2  a >> k3  b

Re: [GENERAL] Horizontal aggregation?

2012-04-13 Thread Abel Abraham Camarillo Ojeda
On Sat, Apr 14, 2012 at 1:22 AM, wrote: > > > Hi, > > I am looking for a feature that would select from a table with > k1  a > k1  b > k1  c > k2  a > k3  b > k3  c > something like > k1  a b c > k2  a > k3  b c > (Just all elements next to each other, with a space in between) > or perhaps an arr

[GENERAL] Horizontal aggregation?

2012-04-13 Thread hamann . w
Hi, I am looking for a feature that would select from a table with k1 a k1 b k1 c k2 a k3 b k3 c something like k1 a b c k2 a k3 b c (Just all elements next to each other, with a space in between) or perhaps an array output k1 {a,b,c] k2 {a} k3 {b,c} If such an operator exists, woul