Home > mailing lists

Concatenating string fields with GROUP BY clause - Mailing list pgsql-novice

From	Brian G. Huber
Subject	Concatenating string fields with GROUP BY clause
Date	September 9, 2003 17:04:04
Msg-id	001b01c376f4$124dc410$6400a8c0@bghmobile Whole thread Raw
Responses	Re: Concatenating string fields with GROUP BY clause
List	pgsql-novice

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

From: Tom Lane
Date: 09 September 2003, 16:24:26
Subject: Re: Modifying pg_shadow?

From: Jason Hihn
Date: 09 September 2003, 17:08:25
Subject: Re: Modifying pg_shadow?