Simon Slavin wrote: > I think that the documentation doesn't sufficiently explain the problem. > Or maybe the use of IN or lists deserves its own page rather than being > buried in the extremely long page on expressions.
<https://www.sqlite.org/rowvalue.html> says: | For a row-value IN operator, the left-hand side … can be either | a parenthesized list of values or a subquery with multiple columns. But | the right-hand side … must be a subquery expression. I'd guess this restriction makes parsing easier. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
