Correct way of using node-postgres select with IN clause

Question

I am trying to workout how to pass in a comma sepated string of values into a postgres select within in clause query using node-postgres but unfortunately can't seem to get it working and can't find any examples.

I have the following code:

function getUser() {
  let inList = "'qwerty', 'qaz'";

  const result = await pgPool.query("SELECT name FROM my_table WHERE info IN ($1)", [inList]);  
  if (result.rowCount == 1) return result.rows.map(row => row.name)
  return false
}

Basically want the end result query to process:

SELECT name FROM my_table WHERE info IN ('qwerty', 'qaz')

Unsure if this is actually the correct way of doing this with pgPool?

Clemb8 · Accepted Answer · 2021-09-28 07:06:09Z

6

The right way is in the FAQ on Github --> https://github.com/brianc/node-postgres/wiki/FAQ#11-how-do-i-build-a-where-foo-in--query-to-find-rows-matching-an-array-of-values

You should be able to do it that way :

 pgPool.query("SELECT name FROM my_table WHERE info = ANY ($1)", [jsArray], ...);

answered Sep 28, 2021 at 7:06

Clemb8

722 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Correct way of using node-postgres select with IN clause

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related