Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tdmm3-00088E-83 for pgsql-sql@arkaria.postgresql.org; Wed, 28 Nov 2012 18:54:20 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Tdmm2-0001Di-NF for pgsql-sql@arkaria.postgresql.org; Wed, 28 Nov 2012 18:54:18 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TdmlP-000147-3T for pgsql-sql@postgresql.org; Wed, 28 Nov 2012 18:53:39 +0000 Received: from nm17-vm2.bullet.mail.ne1.yahoo.com ([98.138.91.93]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TdmlN-0007yW-IP for pgsql-sql@postgresql.org; Wed, 28 Nov 2012 18:53:38 +0000 Received: from [98.138.90.51] by nm17.bullet.mail.ne1.yahoo.com with NNFMP; 28 Nov 2012 18:53:36 -0000 Received: from [76.13.13.44] by tm4.bullet.mail.ne1.yahoo.com with NNFMP; 28 Nov 2012 18:53:36 -0000 Received: from [127.0.0.1] by smtp105.prem.mail.ac4.yahoo.com with NNFMP; 28 Nov 2012 18:53:36 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1354128816; bh=tl9/MyhEhamPF65NxVA3Bkejsaf/E5yJYLBaxx07CI0=; h=X-Yahoo-Newman-Id:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:From:To:Cc:References:In-Reply-To:Subject:Date:Message-ID:MIME-Version:Content-Type:Content-Transfer-Encoding:X-Mailer:Thread-Index:Content-Language; b=X93+WmAaURbNR+aWxuNdw9eT4/cySmSqxeWeUje6LPvCLuKrOhAy2aO1Fz182LNETMBljqeqHjjLykFByE6+a1iprpxZ0YrR0urFZ88z3FBF//wHNHJphm/hz+yEu5paRH89mHhkxWg86RqRv/pYBfw9CaJsSpoLkHfpkOOoPhE= X-Yahoo-Newman-Id: 608129.42994.bm@smtp105.prem.mail.ac4.yahoo.com X-Yahoo-Newman-Property: ymail-3 X-YMail-OSG: uz8J7jYVM1miD_kqvsU6Q5iIMQG9qxjR_n_h00lqavKWXWW SzzjygJlptQlkQm5RQnE1UssUKVTZ90bnMUi872BlSsH.Mb.GixWTp34hlWb 3lXKtzSWPN0JfZiaSlQfrhBSgvdGM_2tDMHcbzaJdnY25a8QFPm0.ZNv.15z hZJN7daZM2AW9UGc.ArlESCNVYc1K9CUfn3jbCVARefEezz9h_z_TSLr01bR 0zcPuChsUVKlEYfbUCaA_ApAHPc14ix7PiuihtC3Pwi1_CaGxt_dLQBDECBQ pZZLBd1pfiiRrN49mlydA3LeNnRmRWKqRCGeecHipr2H_sQrrClls9x6AYIP tfLbSSoQwBkObPJTQAXl8V9opZYrXennrIUwc7Y8tjnVaiGPbVey8ZTaG4b0 Ob6jauanswSgfQeDGJpvze1FIOEN4PWctsLH.uuyoy99fnswl.QLisWVYiEX 79Vc- X-Yahoo-SMTP: mpGJl6eswBD2IBufoVEg0Pa8gg-- Received: from WolfDog (polobo@24.93.28.86 with login) by smtp105.prem.mail.ac4.yahoo.com with SMTP; 28 Nov 2012 10:53:36 -0800 PST From: "David Johnston" To: "'Oliver d'Azevedo Cristina'" , "'JORGE MALDONADO'" Cc: References: <2829F543-88A7-496D-AB22-6D5ECBBB4633@gmail.com> In-Reply-To: <2829F543-88A7-496D-AB22-6D5ECBBB4633@gmail.com> Subject: Re: Joining several rows into only one Date: Wed, 28 Nov 2012 13:52:27 -0500 Message-ID: <00df01cdcd99$83d18850$8b7498f0$@yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Outlook 14.0 Thread-Index: AQH9dMTG64aAP8VyoMjdIc0LOF1YZQGPurzMl5PLO4A= Content-Language: en-us X-Pg-Spam-Score: -0.4 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org > -----Original Message----- > From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql- > owner@postgresql.org] On Behalf Of Oliver d'Azevedo Cristina > Sent: Wednesday, November 28, 2012 1:42 PM > To: JORGE MALDONADO > Cc: pgsql-sql@postgresql.org > Subject: Re: [SQL] Joining several rows into only one >=20 > You need to use the array_agg() and array_to_string() functions. >=20 Or you can skip directly to the "string_agg(expression, delimiter)" functio= n. See http://www.postgresql.org/docs/9.2/interactive/functions-aggregate.html= for more information on aggregate-related functions. David J. --=20 Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql