Re: merge multiple records into 1

From: CoL <col(at)mportal(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: merge multiple records into 1
Date: 2003-08-24 17:17:03
Message-ID: biarpp$2v4f$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Dunstan 2003-08-24 19:15:25 Re: Single-file DBs WAS: Need concrete 'Why Postgres
Previous Message pgman 2003-08-24 14:38:57 Your details