On February 4, 2020 7:10:52 p.m. EST, Scott Perry <num...@apple.com> wrote: >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 :)
Not everyone has access to carrays and intarrays, either, such as PHP users like myself. -- J. King _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
