On Tue, Jan 2, 2018 at 5:46 PM, petern <peter.nichvolo...@gmail.com> wrote: > Hi Scott. > >>Are there other aggregate functions that take multiple arguments? > > Absolutely. I've got a few in my code which deserialize table rows into > runtime objects. Fortunately, the DISTINCT filter makes no sense in that > use case, so I didn't bump into this issue myself.
Thanks for the info. In doing some quick searches, I found multiple descriptions of "generic SQL" aggregates that gave a syntax of "aggregate([DISTINCT|ALL] expression)", which led me to assume that maybe the standard only allows that syntax with a single expression, not an expression list. I say maybe because the examples I found were clearly not the standard. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users