How to get a result in one row

Поиск
Список
Период
Сортировка
От virgi@lettere.unipd.it
Тема How to get a result in one row
Дата
Msg-id 20060621150612.GA6246@fedro.lettere.unipd.it
обсуждение исходный текст
Ответы Re: How to get a result in one row
Список pgsql-sql
Hi!

I'm using PostgreSQL 7.4.7.

table_cid | nick   
----+------ 1 | T       2 | S      3 | G       4 | A       5 | D      
...

table_m  id |  c
------+----
22192 |  4
15041 |  3
21764 |  5
22192 |  1
15041 |  4
15041 |  2
...
where table_m.c is a foreign key on table_c.id

SELECT table_m.id,table_c.nickFROM table_m AS m JOIN table_c AS c ON c.id=m.c WHERE m.id=22192 ORDER BY c.nick;

returns:  id | nick   
------+------
22192 | A      
22192 | T      
(2 rows)

I'd like to get the result in only one row:  id | nick
------+------
22192 | A,T

(and similarly: 15041 | A,G,S )

As table_c can increase, I don't want to use the case construct.
How can I do? Maybe writing a function. But how?

TIA!
virgi


В списке pgsql-sql по дате отправления:

Предыдущее
От: Frank Bax
Дата:
Сообщение: Re: Displaying first, last, count columns
Следующее
От: Jeff Frost
Дата:
Сообщение: Re: keeping last 30 entries of a log table