How to collect text-fields from multiple rows ?
От | Andreas |
---|---|
Тема | How to collect text-fields from multiple rows ? |
Дата | |
Msg-id | 4CB91AAE.6030602@gmx.net обсуждение исходный текст |
Ответы |
Re: How to collect text-fields from multiple rows ?
|
Список | pgsql-sql |
Hi, how can I collect text-fields from multiple rows into one output row? I'd like to do an equivalent to the aggregate function SUM() only for text. The input is a select that shows among other things a numerical column where I would like to group by. The text column of all rows in a group should get concatenated into 1 text devided by a '\n'. Even better would be if I could add a second text colum per line as topic. Input e.g. select group_nr::integer, memo::text, topic::text ... 1, 'bla ', 'weather' 2, 'yada..', 'weather' 2, 'talk talk..', 'cooking' 2, 'words words, ...', 'poetry' 3, .... Output: 1, 'weather\nbla...' 2, 'weather\nyada..\ncooking\ntalk talk..\npoetry\nwords words, ...' Even better would be to get some kind of line-chars as optical devider between the topics. Lets say 10 = above all topic-lines. 2, '==========\nweather\nyada..\n==========\ncooking\ntalk talk..\n==========\npoetry\nwords words, ...'
В списке pgsql-sql по дате отправления: