Your details

See the attached file for details
>From pgsql-general-owner(at)postgresql(dot)org Sun Aug 24 13:16:53 2003
X-Original-To: pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (unknown [64.117.224.130])
by svr1.postgresql.org (Postfix) with ESMTP id 660E1D1B4F0
for <pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Sun, 24 Aug 2003 13:16:51 -0300 (ADT)
Received: from svr1.postgresql.org ([64.117.224.193])
by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024)
with ESMTP id 92522-04
for <pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Sun, 24 Aug 2003 13:16:41 -0300 (ADT)
Received: from wolff.to (wolff.to [66.93.249.74])
by svr1.postgresql.org (Postfix) with SMTP id 59DE6D1D185
for <pgsql-general(at)postgresql(dot)org>; Sun, 24 Aug 2003 13:16:40 -0300 (ADT)
Received: (qmail 11487 invoked by uid 500); 24 Aug 2003 16:22:30 -0000
Date: Sun, 24 Aug 2003 11:22:30 -0500
From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Brian Maguire <bmaguire(at)vantage(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: merge multiple records into 1
Message-ID: <20030824162230(dot)GA11448(at)wolff(dot)to>
Mail-Followup-To: Brian Maguire <bmaguire(at)vantage(dot)com>,
pgsql-general(at)postgresql(dot)org
References: <2F2E24372F10744588A27DEECC85FE040103E7EB(at)vt-pe2550-001(dot)vantage(dot)vantage(dot)com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <2F2E24372F10744588A27DEECC85FE040103E7EB(at)vt-pe2550-001(dot)vantage(dot)vantage(dot)com>
User-Agent: Mutt/1.5.4i
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/1285
X-Sequence-Number: 47701

On Sat, Aug 23, 2003 at 20:16:51 -0400,
Brian Maguire <bmaguire(at)vantage(dot)com> wrote:
> 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

You could write an aggregate function that concatenates strings. There should
even be examples of some code that does this in the archives from within
the last 6 months.