The documentation for aggregate functions states that "In any aggregate function that takes a single argument, that argument can be preceded by the keyword DISTINCT". My questions are: Why is DISTINCT only allowed with a single argument in a function like GROUP_CONCAT? Can that limitation be removed?
I'm in the situation where I need to use GROUP_CONCAT and filter out duplicates at the same time. And the default comma separator in GROUP_CONCAT needs to be replaced by a space. I've tried to use function REPLACE to get rid of the comma but only to realise that the data being concatenated also might contain one or more commas. Staffan _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
