sql-agg-csv.sql

/* ########################### 
set up table and populate it 
############################# */

DROP TABLE IF EXISTS t;
CREATE TEMP TABLE t (k varchar, v varchar);
INSERT INTO t VALUES ('1', 'a,b,c');
INSERT INTO t VALUES ('1', 'a,d,e');
INSERT INTO t VALUES ('2', 'e,f');

/* #####################
output wanted

k   v
--  ---------
1   a,b,c,d,e
2   e,f
################  */