I would like to take several rows from a select and have them grouped into one row with the text contents of one field in all the rows concatenated into one field in the single row of the group group. The contents of the other fields are identical across the rows.

This is the complementary action to regexp_split_to_table.

Grouping by summing numerical fields seems to be straightforward, but grouping by concatenating text fields escapes my search of the documentation.

Thanking you for your patience,

John

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to