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 <jorgemal1...@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 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? > > Respectfully, > Jorge Maldonado > -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
