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

Reply via email to