<div>
I can't give the real answer, but several thousand entries should work.
</div>


I can't give the real answer, but several thousand entries should work.

<div>
Check whether this answers:<br />
<br />
<a href="http://stackoverflow.com/questions/1009706/postgresql-max-number-of-parameters-in-in-clause" rel="ugc">http://stackoverflow.com/questions/1009706/postgresql-max-number-of-parameters-in-in-clause</a><br />
<br />
&gt;&nbsp;After exploring , it is not limited , so you can handle theoretically &nbsp;any number of values as long &gt;&nbsp;as it not pass the string max size (4GB)<br />
Also, can you share the web link for this answer?<br />
<br />

</div>


Check whether this answers:

http://stackoverflow.com/questions/1009706/postgresql-max-number-of-parameters-in-in-clause [http://stackoverflow.com/questions/1009706/postgresql-max-number-of-parameters-in-in-clause]

> After exploring , it is not limited , so you can handle theoretically  any number of values as long > as it not pass the string max size (4GB)
Also, can you share the web link for this answer?



<div>
<div class="content wysiwyg-content">
HI <br />
<br />
Is there any limit to the number of elements in the IN clause of &nbsp;SELECT in Postgres ?<br />
<br />
Thanks
</div>
</div>


HI 

Is there any limit to the number of elements in the IN clause of  SELECT in Postgres ?

Thanks

What is the limit on the number of elements in the IN clause of  SELECT

PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. PostgreSQL implements the majority of the SQL2011 standard, is ACID-compliant and transactional using multiversion concurrency control (MVCC), and handles complex SQL queries using many indexing methods that are not available in other databases. It is cross-platform and runs on many operating systems including Linux, FreeBSD, OS X, Solaris, and Microsoft Windows.