On Wed, Dec 10, 2008 at 11:28 AM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > On Wed, Dec 10, 2008 at 11:08 AM, Said Ramirez <sramirez@xxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
