On Nov 28, 2012, at 1:33 PM, JORGE MALDONADO wrote: > I have a SELECT statement that gives me a result like this: > > SONG ARTIST > ----------------------------------- > Song1 Artist1 > Song1 Artist2 > Song1 Artist3 > Song2 Artist2 > Song3 Artist4 > Song4 Artist1 > Song5 Artist4 > > As you can see, the same song may belong to more than one artist, and this is > fine. What I would like to do is NOT to get several rows, one for each > different artist, but to join all of the artists in one column and display > only one row. > Is this possible?
Hi Jorge, Try the array_agg function: SELECT song, array_agg(artist) FROM table GROUP BY song; Best, Jonathan -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql