PostgreSQL – max number of parameters in “IN” clause?

by

According to the source code located here, starting at line 850, PostgreSQL doesn’t explicitly limit the number of arguments.

The following is a code comment from line 870:

/*
 * We try to generate a ScalarArrayOpExpr from IN/NOT IN, but this is only
 * possible if the inputs are all scalars (no RowExprs) and there is a
 * suitable array type available.  If not, we fall back to a boolean
 * condition tree with multiple copies of the lefthand expression.
 * Also, any IN-list items that contain Vars are handled as separate
 * boolean conditions, because that gives the planner more scope for
 * optimization on such clauses.
 *
 * First step: transform all the inputs, and detect whether any are
 * RowExprs or contain Vars.
 */

More Related Contents:

  1. Insert, on duplicate update in PostgreSQL?
  2. How does the search_path influence identifier resolution and the “current schema”
  3. How do you find the row count for all your tables in Postgres
  4. Run batch file with psql command without password
  5. Postgresql: Conditionally unique constraint
  6. How do you use variables in a simple PostgreSQL script?
  7. How to make “case-insensitive” query in Postgresql?
  8. Rownum in postgresql
  9. How to switch databases in psql?
  10. Postgresql: Scripting psql execution with password
  11. dynamic sql query in postgres
  12. Is there a timeout for idle PostgreSQL connections?
  13. How to make connection to Postgres via Node.js
  14. docker postgres pgadmin local connection
  15. Find difference between timestamps in seconds in PostgreSQL
  16. Unable to connect PostgreSQL to remote database using pgAdmin
  17. How can I change a PostgreSQL user password?
  18. Docker wait for postgresql to be running
  19. I forgot the password I entered during PostgreSQL installation
  20. Function to loop through and select data from multiple tables
  21. SQL query column does not exist error
  22. Postgresql enforce unique two-way combination of columns
  23. Composite PRIMARY KEY enforces NOT NULL constraints on involved columns
  24. how to store PostgreSQL jsonb using SpringBoot + JPA?
  25. Orbeon Forms Postgres DB connection
  26. How to delete an enum type value in postgres?
  27. Why unsigned integer is not available in PostgreSQL?
  28. now() default values are all showing same timestamp
  29. What’s the difference between pg_table_size, pg_relation_size & pg_total_relation_size? (PostgreSQL)
  30. JPA and PostgreSQL with GenerationType.IDENTITY

Leave a Comment