combine multiple row values in to one row
От | Lee Harr |
---|---|
Тема | combine multiple row values in to one row |
Дата | |
Msg-id | SNT106-W53280548BAAF282C4E32C1B12B0@phx.gbl обсуждение исходный текст |
Ответы |
Re: combine multiple row values in to one row
Re: combine multiple row values in to one row Re: combine multiple row values in to one row |
Список | pgsql-general |
Hi; I'm looking for a way to do this: # \d tbl Table "public.tbl" Column | Type | Modifiers --------+---------+----------- idn | integer | code | text | # SELECT * FROM tbl; idn | code -----+------ 1 | A 2 | B 2 | C 3 | A 3 | C 3 | E (6 rows) # select idn, magic() as codes FROM tbl; idn | codes -----+------ 1 | A 2 | B, C 3 | A, C, E (3 rows) Right now, I use plpgsql functions, but each time I do it I have to rewrite the function to customize it. Is there a generic way to do this? An aggregate maybe? Thanks for any help. _________________________________________________________________ Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us
В списке pgsql-general по дате отправления: