From: John Gage <jsmgage@numericable.fr>
To: pgsql-sql@postgresql.org
Subject: How do you do the opposite of regexp_split_to_table?
Date: Tue, 3 Aug 2010 22:21:58 +0200
Message-ID: <4FA8D090-F145-485B-9062-7136CB8B6CB0@numericable.fr> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jsmgage@numericable.fr
Subject: Re: How do you do the opposite of regexp_split_to_table?
In-Reply-To: <4FA8D090-F145-485B-9062-7136CB8B6CB0@numericable.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox