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

You need to use the array_agg() and array_to_string() functions.

Best,
Oliver

Enviado via iPhone

Em 28/11/2012, às 06:33 PM, JORGE MALDONADO <jorgemal1960@gmail.com> escreveu:

> 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?
>
> Respectfully,
> Jorge Maldonado
>