On 23 Apr 2019, at 4:14pm, Charles Leifer <colei...@gmail.com> wrote:
> SELECT * FROM info WHERE (year,month,day) IN ((2019, 1, 1), (2019, 2, 1)); > > Perhaps the row-value doc could clarify the behavior of IN with row values? This > ((2019, 1, 1), (2019, 2, 1)) is not a list of scalers, it's a list of lists of scalers. So the documentation does explain it. However, 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. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
