PostgreSQL - “IN”子句中参数的最大数量

PostgreSQL - “IN”子句中参数的最大数量

sql
SELECT * FROM customers WHERE id IN (1, 2, 3);

sql
CREATE TABLE products (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100)
);

sql
INSERT INTO products (name) VALUES
    ('product1'), ('product2'), ('product3'), ... ('product1001');

sql
SELECT * FROM products WHERE id IN (1, 2, 3, ..., 1001);

sql
SELECT * FROM products WHERE id IN (1, 2, 3, ..., 1000)
UNION ALL
SELECT * FROM products WHERE id = 1001;