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

From David Johnston
Subject Re: Joining several rows into only one
Date
Msg-id 00df01cdcd99$83d18850$8b7498f0$@yahoo.com
Whole thread Raw
In response to Re: Joining several rows into only one  (Oliver d'Azevedo Cristina <oliveiros.cristina@gmail.com>)
List pgsql-sql
> -----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
>
> You need to use the array_agg() and array_to_string() functions.
>

Or you can skip directly to the "string_agg(expression, delimiter)" function.

See http://www.postgresql.org/docs/9.2/interactive/functions-aggregate.html for more information on aggregate-related
functions.

David J.





pgsql-sql by date:

Previous
From: Oliver d'Azevedo Cristina
Date:
Subject: Re: Joining several rows into only one
Next
From: Seb
Date:
Subject: \copy multiline