How do you do the opposite of regexp_split_to_table? - Mailing list pgsql-sql

From John Gage
Subject How do you do the opposite of regexp_split_to_table?
Date
Msg-id 4FA8D090-F145-485B-9062-7136CB8B6CB0@numericable.fr
Whole thread Raw
Responses Re: How do you do the opposite of regexp_split_to_table?  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Backslash characters in PLPGSQL
Next
From: Alvaro Herrera
Date:
Subject: Re: How do you do the opposite of regexp_split_to_table?