Details
-
New Feature
-
Status: Resolved
-
Minor
-
Resolution: Fixed
-
0.11.3
-
None
Description
I'll implement to concatenate the strings of a field within a group by query.
I have a table:
ID COMPANY_ID EMPLOYEE
1 1 Anna
2 1 Bill
3 2 Carol
4 2 Dave
and I wanted to group by company_id to get something like:
SELECT company_id, string_agg(employee, ', ')
FROM mytable
GROUP BY company_id;
COMPANY_ID EMPLOYEE
1 Anna, Bill
2 Carol, Dave
PostgreSQL supports string_agg function.
http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE
Thank you.
Attachments
Issue Links
- links to