Hi all, I want to make an aggregate function that concatenates strings from a certain column into one cell in a group by clause. For example I have the following table :
Type Text ================= 1 text1 2 text2 1 text3 3 text4 2 text5 I need a query that group by type and concats the text columns to produce something like the following : 1 text1, text3 2 text2, text5 3 text4 I am aware that this can be done through recursive joins but this is too complicated and heavy. Any suggestions? Regards ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
