Re: [sqlite] Relax "DISTINCT aggregates" error

2019-11-18 Thread Jose Isaias Cabrera
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

Re: [sqlite] Relax "DISTINCT aggregates" error

2019-11-18 Thread Dominique Devienne
On Fri, Nov 15, 2019 at 4:22 PM Jose Isaias Cabrera 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.

Re: [sqlite] Relax "DISTINCT aggregates" error

2019-11-15 Thread Jose Isaias Cabrera
Dominique Devienne, on Friday, November 15, 2019 09:02 AM, wrote... > > As can be seen below, the last query fail, despite the one before it > succeeding. > Yet the second argument is constant, thus it would seem "natural" for it to > work as well. > Could the error be "relaxed", when the

[sqlite] Relax "DISTINCT aggregates" error

2019-11-15 Thread Dominique Devienne
As can be seen below, the last query fail, despite the one before it succeeding. Yet the second argument is constant, thus it would seem "natural" for it to work as well. Could the error be "relaxed", when the non-first argument(s) to aggregate functions are constant? Thanks, --DD