Re: IN limit

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Said Ramirez" <sramirez(at)vonage(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: IN limit
Date: 2008-12-10 18:28:37
Message-ID: dcc563d10812101028i419158b8x27ebb7e3c9f3243e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

  • IN limit at 2008-12-10 18:08:20 from Said Ramirez

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-12-10 18:35:12 Re: IN limit
Previous Message Guy Rouillier 2008-12-10 18:18:00 Re: Ubuntu for servers (was TurnKey PostgreSQL)