On Fri, 23 Sep 2016 16:35:07 +0000 Quan Yong Zhai <q...@msn.com> wrote:
> Quote << > A "row value" is an ordered list of two or more scalar values. In > other words, a "row value" is a vector.>> > > A ?row value? is a tuple, not a vector. When your using a tuple, you > know how many items in it, and the type of each item of it. That's correct, and addresses Dominique's point, albeit obliquely: to use a row-value as a list-argument to IN would be to confuse rows and columns. A row-value has 1 or more columns, but only one row. It would be nice to use row-values correctly in IN: select * from T where (a,b) IN ( (1, 'a'), (2, 'b') ) Is that valid? --jkl _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users