Sometimes, we want to execute a "WHERE col IN ()" query with node-postgres.
In this article, we’ll look at how to execute a "WHERE col IN ()" query with node-postgres.
How to execute a "WHERE col IN ()" query with node-postgres?
To execute a "WHERE col IN ()" query with node-postgres, we can use the client.query method.
For instance, we write
const ids = [1, 3, 4];
const q = client.query('SELECT Id FROM MyTable WHERE Id = ANY($1::int[])', [ids]);
q.on('row', (row) => {
console.log(row);
})
to call client.query with the parameterized SQL string, and an array of values we set as the parameter values.
We add ids as the value of the value of ANY($1::int[]).
Then we call q.on with 'row' to return the query results and get the result from the row parameter.
Conclusion
To execute a "WHERE col IN ()" query with node-postgres, we can use the client.query method.
