Re: Re: plpgsql, I have a solution, want to see if there is a cleaner/better one. Taking vertical list and comma separating it onto a row

Поиск
Список
Период
Сортировка
От Henry Drexler
Тема Re: Re: plpgsql, I have a solution, want to see if there is a cleaner/better one. Taking vertical list and comma separating it onto a row
Дата
Msg-id CAAtgU9QKy29ZzTuiZTjuK50QOZxVp-ATpzrw=+g7S3+qsj_zJw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: plpgsql, I have a solution, want to see if there is a cleaner/better one. Taking vertical list and comma separating it onto a row  (Thomas Kellerer <spam_eater@gmx.net>)
Ответы Re: Re: plpgsql, I have a solution, want to see if there is a cleaner/better one. Taking vertical list and comma separating it onto a row  ("David Johnston" <polobo@yahoo.com>)
Список pgsql-general
Дерево обсуждения


On Thu, Nov 10, 2011 at 8:34 AM, Thomas Kellerer <spam_eater@gmx.net> wrote:


SELECT type,
      string_agg(color, ',') as organized_by_type
FROM clothes
GROUP BY type;



wow, yes that is cleaner.

Thank you for taking the time - obviously I need to read through the string functions again. 

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

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: plpgsql, I have a solution, want to see if there is a cleaner/better one. Taking vertical list and comma separating it onto a row
Следующее
От: David Johnston
Дата:
Сообщение: Re: plpgsql, I have a solution, want to see if there is a cleaner/better one. Taking vertical list and comma separating it onto a row