How do I write postgres IN operator query in express js(node js)

Question

How I wrote

var staff=[1,2,3];
await client.query(
    "SELECT user_id FROM group_user WHERE user_id IN($1)",
    staffs
);

Throws error that only one parameter need to be given

You can find some options [here](https://stackoverflow.com/q/10720420) for node-postgres. — Ryan, Jul 02 '21 at 11:44

score 0 · Answer 1 · answered Jul 02 '21 at 13:19

0

Can you try this?

`SELECT user_id FROM group_user WHERE user_id in (${ids})`

answered Jul 02 '21 at 13:19

Barış Yenigün

1 Answers1