Re: Concatenating string fields with GROUP BY clause

-----Original Message-----
From: Brian G. Huber [mailto:brianghuber@yahoo.com]
Sent: Tuesday, September 09, 2003 12:02 PM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Concatenating string fields with GROUP BY clause

Hi -

 

I am trying to concatenate a text field in a query with a group by clause, similar to a sum() function on a numeric value - for example:

 

SELECT groupid, sum(numeric_field), ???(text_field) FROM table GROUP BY groupid

 

but I cannot find a function that will concatenate the text fields. Any comments appreciated!

 

TIA,BGH