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 по дате отправления: