Re: Concatenating string fields with GROUP BY clause

Section 6.4

string || string String concatenation 'Post' || 'greSQL' = PostgreSQL

-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Brian G. Huber
Sent: Tuesday, September 09, 2003 1:02 PM
To: pgsql-novice(at)postgresql(dot)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