On Wed, Dec 10, 2008 at 11:28 AM, Scott Marlowe <[EMAIL PROTECTED]> wrote: > On Wed, Dec 10, 2008 at 11:08 AM, Said Ramirez <[EMAIL PROTECTED]> 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
