I'm not saying this is good or best but:
select distinct a.c1, array_to_string(array(select c2 from t1 as b where
b.c1 = a.c1),',')
from t1 as a;
c1 | array_to_string
----+-----------------
1 | val1,val2,val3
2 | val1
3 | val5,val6
(3 rows)
On Tue, Feb 8, 2011 at 2:35 PM, Emi Lu <em...@encs.concordia.ca> wrote:
> Good afternoon,
>
> Is there a method to retrieve the following results:
>
> T1(c1 int, c2 varchar(128) )
> ---------------------------------
>
>
> (1, val1);
> (1, val2);
> (1, val3);
> (2, val1);
> (3, val5);
> (3, val6);
>
> select c1, method(c2)
> group by c1
>
> returns:
> ============
> 1, "val1, val2, val3"
> 2, "val1"
> 3, "val5, val6"
>
>
> Thanks a lot!
>
> --
> Lu Ying
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
--
Peter Steinheuser
psteinheu...@myyearbook.com
