On 13 Apr 2018, at 8:40am, Mark Brand <mabr...@mabrand.nl> wrote: > It also occurs to me that COUNT() should work (but doesn't) over sets of row > values: > > sqlite> select count((1,2)); > Error: row value misused > > I would expect it to return the number of non-NULL row values in the set.
What should this do, and why ? CREATE TABLE MyTable (a INTEGER, b, INTEGER, c INTEGER); INSERT INTO MyTable VALUES (1, 1, 1); INSERT INTO MyTable VALUES (2, 2, 2); ... INSERT INTO MyTable VALUES (10, 10, 10); SELECT COUNT(a, b, c) FROM MyTable; Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
