Forum OpenACS Q&A: IN clause limitation
I need to serach records using IN clause .. There i have more than 1000 parameters to give in IN clause.
Is there any way i can give more than 1000 parameters in the IN clause, Because i have data in Bulk.. lets say i need to search records with 50000 parameters.
select abc,xyz from test where xyz in (1,2,3,.......,1000,......2000,....5000)
Is there anyway i can do it???
For example, quoting from the above page: "if you have such a seriously big inlist -- i would suggest you do not use this technique but consider loading the stuff into a global temporary table using bulk inserts and then query "where in (select * from gtt)""