merge multiple records into 1

From: "Brian Maguire" <bmaguire(at)vantage(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: merge multiple records into 1
Date: 2003-08-24 00:16:51
Message-ID: 2F2E24372F10744588A27DEECC85FE040103E7EB@vt-pe2550-001.vantage.vantage.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2003-08-24 02:35:34 Re: determine how many matches of a string in a field
Previous Message Anastasios Hatzis 2003-08-23 15:02:29 Surveys & Studies: FLOSS - Usage of Free/Libre Open Source Software (PostgreSQL, etc.)