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

Reply via email to