Horizontal aggregation? - Mailing list pgsql-general

From hamann.w@t-online.de
Subject Horizontal aggregation?
Date
Msg-id wolfgang-1120414082256.A0126706@amadeus3.local
Whole thread Raw
Responses Re: Horizontal aggregation?  (Abel Abraham Camarillo Ojeda <acamari@the00z.org>)
List pgsql-general

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, would there be a "remove duplicates" option?

Regards
Wolfgang Hamann


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Error with compile source code on CentOS5.7
Next
From: Abel Abraham Camarillo Ojeda
Date:
Subject: Re: Horizontal aggregation?