afaik "group_concat(distinct a, ',')" is not allowed. "group_concat(distinct a)" or "group_concat(a, ',')" do work. It is mentioned somewhere in the docs.
Jan Am 22.09.2010 14:00, schrieb Wiktor Adamski: > SQLite version 3.7.2 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> create table t(a); > sqlite> select group_concat(distinct a) from t; > > sqlite> select group_concat(distinct a, ',') from t; > Error: DISTINCT aggregates must have exactly one argument > > Both queries should return the same result. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
