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@xxxxxxxxx>]

 

From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Henry Drexler
Sent: Thursday, November 10, 2011 8:42 AM
To: Thomas Kellerer
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: 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

 

 

On Thu, Nov 10, 2011 at 8:34 AM, Thomas Kellerer <spam_eater@xxxxxxx> 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.