Re: IN limit

On Wed, Dec 10, 2008 at 11:28 AM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Wed, Dec 10, 2008 at 11:08 AM, Said Ramirez <sramirez(at)vonage(dot)com> wrote:
>> Is there a limit to the number of entries I can pass in an IN clause as part
>> of a SELECT statement? As in
>> SELECT baz FROM foo where id in ( 1, 2,... ) ;
>
> I think it's high enough you'd have performance problems before it
> would fail. If there even is one.

Just tested it with a subselect with 10M rows in an in clause. Not
sure if that's the same as literal strings though.