On Feb 4, 2020, at 12:26 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 4 Feb 2020, at 7:13pm, Deon Brewis <de...@outlook.com> wrote: > >> WHERE x IN (?1,?2,?3,?4...,?1000 ) > > People really do this ? Sheesh.
It's a pretty common pattern. Sure, queries that are likely to use very large IN groups ought to be using carray or intarray but not everyone knows they exist :) Scott _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users