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
<emilu@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
psteinheuser@myyearbook.com
