By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,793 Members | 1,470 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,793 IT Pros & Developers. It's quick & easy.

merge multiple records into 1

P: n/a
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


---------------------------(end of broadcast)---------------------------TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to ma*******@postgresql.org so that your message can get through to the mailing list cleanly

Nov 11 '05 #1
Share this Question
Share on Google+
2 Replies

P: n/a
On Sat, Aug 23, 2003 at 20:16:51 -0400,
Brian Maguire <bm******@vantage.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.

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 11 '05 #2

P: n/a
CoL
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.

Nov 11 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.