Dominique Devienne, on Monday, November 18, 2019 04:33 AM, wrote... > > On Fri, Nov 15, 2019 at 4:22 PM Jose Isaias Cabrera, on > 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
Yes, understood. josé _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users