Re: Joining several rows into only one

Поиск
Список
Период
Сортировка
От David Johnston
Тема Re: Joining several rows into only one
Дата
Msg-id 00df01cdcd99$83d18850$8b7498f0$@yahoo.com
обсуждение исходный текст
Ответ на Re: Joining several rows into only one  (Oliver d'Azevedo Cristina <oliveiros.cristina@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Oliver d'Azevedo Cristina
Дата:
Сообщение: Re: Joining several rows into only one
Следующее
От: Seb
Дата:
Сообщение: \copy multiline