Julian Hyde created CALCITE-683:
-----------------------------------
Summary: String aggregates
Key: CALCITE-683
URL: https://issues.apache.org/jira/browse/CALCITE-683
Project: Calcite
Issue Type: Bug
Reporter: Julian Hyde
Assignee: Julian Hyde
Per http://www.sql-workbench.net/comparison/string_aggregates.html, aggregate
multiple string values to a single value, optionally delimited.
{code}select d.department_id,
d.department_name,
string_agg(e.first_name, ',' order by first_name) as all_employees
from departments d
join employees e on d.department_id = e.department_id
group by d.department_id
order by d.department_id;
department_id | department_name | all_employees
--------------+------------------+-------------------------
10 | Road consruction | Prostetnic Vogon Jeltz
20 | Hiking | Arthur, Ford
30 | Shipping | Zaphod
40 | Engineering | Marvin, Tricia{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
