On 23-4-2019 18:08, Simon Slavin wrote:
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))
This works:
SELECT * FROM info WHERE (year,month,day) = (2019, 1, 1) OR (year,month,day)
= (2019, 2, 1);
but it's not using IN, and more characters to type
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
