From: [email protected] [mailto:[email protected]] On Behalf Of Henry Drexler Sent: Thursday, November 10, 2011 8:42 AM To: Thomas Kellerer Cc: [email protected] 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 <[email protected]> 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.
