Search Postgresql Archives

Re: Horizontal aggregation?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



On Sat, Apr 14, 2012 at 1:22 AM,  <hamann.w@xxxxxxxxxxx> 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 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
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

select k, array_agg(distinct val ) from t;

See the docs: http://www.postgresql.org/docs/9.1/static/sql-expressions.html#SYNTAX-AGGREGATES

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Programming PHP]     [Kernel Newbies]     [PHP Classes]     [Find Someone Nice]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

Add to Google Powered by Linux