>> 8.0 (and maybe newer releases also) throw dreaded "Stack lenght limit
>> exceeded"
>>
>> message if IN contains large number or items.
>
> Have y'all checked them there release notes? I'm sure they tell the
> tale. (sorry too much True Blood...)
No. I need to support 8.0.
After those crashes I changed all IN clauses to
docid = ANY ({1,2,3,4,5,7,8,96,5445,.., 34534534})
this takes the same number of characters per id as IN clause.
I hope that this does not have any bad effects.
Andrus.