Re: IN limit - Mailing list pgsql-general

From Scott Marlowe
Subject Re: IN limit
Date
Msg-id dcc563d10812101028i419158b8x27ebb7e3c9f3243e@mail.gmail.com
Whole thread Raw
In response to IN limit  (Said Ramirez <sramirez@vonage.com>)
Responses Re: IN limit
List pgsql-general
On Wed, Dec 10, 2008 at 11:08 AM, Said Ramirez <sramirez@vonage.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.

pgsql-general by date:

Previous
From: Guy Rouillier
Date:
Subject: Re: Ubuntu for servers (was TurnKey PostgreSQL)
Next
From: "Scott Marlowe"
Date:
Subject: Re: IN limit