Re: merge multiple records into 1 - Mailing list pgsql-general

From CoL
Subject Re: merge multiple records into 1
Date
Msg-id biarpp$2v4f$1@news.hub.org
Whole thread Raw
In response to merge multiple records into 1  ("Brian Maguire" <bmaguire@vantage.com>)
List pgsql-general
Hi,

how about tablefunc_crosstab from contrib/tablefunc ?

Brian Maguire wrote, On 8/24/2003 2:16 AM:
> What would be the best way to "flatten" a set of records into one column with a query?
>
> example:
>
> You have a table called tbletters
>
> id letters
> 1      a
> 2      b
> 3      c
> 4      d
>
> So I can return this as one column in one record
>
> a,b,c,d
C.


pgsql-general by date:

Previous
From: Jacob Hanson
Date:
Subject: Re: 7.4b1 vs 7.3.4 performance
Next
From: Curt Sampson
Date:
Subject: Re: [HACKERS] Decent VACUUM (was: Buglist)