Re: [sqlite] group_concat(distinct) with empty strings

http://www.sqlite.org/src/info/0deac8737545a020d344be96fff16660a7977ab8 -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] group_concat(distinct) with empty strings

Hinrichsen, John wrote: > Are the results below expected? > sqlite> SELECT (SELECT GROUP_CONCAT(DISTINCT COALESCE(a,'')) FROM z) IS NULL; > 1 You don't need DISTINCT: sqlite> select typeof(group_concat('')); null The documentation says: | The group_concat() function returns a string which is the