From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Henry Drexler
Sent: Thursday, November 10, 2011 8:42 AM
To: Thomas Kellerer
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] 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
On Thu, Nov 10, 2011 at 8:34 AM, Thomas Kellerer <spam_ea...@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.
It isn't a "String Function" but an "Aggregate Function"; classification
can be a pain sometimes - especially when more than one category could
readily apply.
David J.
