Re: Joining several rows into only one - Mailing list pgsql-sql

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
getseveral 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 tableGROUP BY song;

Best,

Jonathan