Re: OR or IN ? - Mailing list pgsql-general

From Andrus
Subject Re: OR or IN ?
Date
Msg-id D71FD5E0C64641B0AF636B66E634A5A6@andrusnotebook
Whole thread Raw
In response to Re: OR or IN ?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: OR or IN ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
>> 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.

pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Annoying Reply-To
Next
From: Alvaro Herrera
Date:
Subject: Re: Drop database / database in use question