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 < [email protected]> wrote: > On Monday, February 22, 2021, Oleksandr Voytsekhovskyy <[email protected]> > 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. > >
