On Fri, Nov 15, 2019 at 4:22 PM Jose Isaias Cabrera <jic...@outlook.com> wrote:
> Dominique Devienne, on Friday, November 15, 2019 09:02 AM, wrote... > > Have you tried this, > sqlite> select group_concat(distinct id || ', ') from t; > 1, ,2, ,4, ,7, > > The only problem is that when the list has a non-distinct. Hmmmm. > That's obviously not the same result (trailing text), and a bit hackish. Clever, but a no-go IMHO. I'm hoping for a "real" fix taking into account the constant-ness of trailing arguments, having only the first arg being row-dependent. --DD _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
