References: 
 <CAAY=A79L1zaxcSoCUzssHogoezEneWA=ZUEu3veHLk86K-EG_g@mail.gmail.com>
In-Reply-To: 
 <CAAY=A79L1zaxcSoCUzssHogoezEneWA=ZUEu3veHLk86K-EG_g@mail.gmail.com>
Mime-Version: 1.0 (iPhone Mail 8L1)
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8
Message-Id: <2829F543-88A7-496D-AB22-6D5ECBBB4633@gmail.com>
Cc: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
From: Oliver d'Azevedo Cristina <oliveiros.cristina@gmail.com>
Subject: Re: Joining several rows into only one
Date: Wed, 28 Nov 2012 18:42:27 +0000
To: JORGE MALDONADO <jorgemal1960@gmail.com>
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

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

Best,
Oliver

Enviado via iPhone

Em 28/11/2012, =C3=A0s 06:33 PM, JORGE MALDONADO <jorgemal1960@gmail.com> e=
screveu:

> I have a SELECT statement that gives me a result like this:
>=20
> SONG     ARTIST
> -----------------------------------
> Song1      Artist1
> Song1      Artist2
> Song1      Artist3
> Song2      Artist2
> Song3      Artist4
> Song4      Artist1
> Song5      Artist4
>=20
> As you can see, the same song may belong to more than one artist, and thi=
s 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?
>=20
> Respectfully,
> Jorge Maldonado
>=20


--=20
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql