Greetings, i have tested both options ANY with string + parsing and simple array - and there are cases when execution time 100+ times worse than IN
On Tue, Feb 23, 2021 at 12:23 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Monday, February 22, 2021, Oleksandr Voytsekhovskyy <a...@uniweb.ua> > wrote: > >> What is the right way to pass long INT values list to IN filter >> > > Don’t. > > Pass in a delimited string, then parse that string into an array and use > “= any(array)”. > > This has the primary benefit of making the input a single parameter. > > David J. > >
