How do I write a SELECT .. WHERE IN clause using NodesJS and Postgresql?

Question

const deptCodes = ['001', '002', '003']

const getMembersQuery = {
   text: 'SELECT member_id FROM member_tbl WHERE dept_code IN ($1) AND delete_flg = 0',
   values: [deptCodes],
   rowMode: 'array'
};
    
const getMembersQuery Result = await client.query(getMembersQuery );

I am writing the above query but I am getting an error, malformed array literal: "001,002,003"\

literals require single quotes 001,002,003 should be '001','002','003' i.e. inside the SQL itself it needs those singles quotes — Paul Maxwell
– Paul Maxwell, Commented Oct 28, 2020 at 1:53
you need to embed single quotes into the string to be evaluated by SQL so that one variable $1 can be interpreted as 3 separate stings each having a start and end single quote with commas between values. For this look at how you escape single quotes e.g. stackoverflow.com/questions/15087497/… — Paul Maxwell
– Paul Maxwell, Commented Oct 30, 2020 at 2:52

Anastasiia Solop · Accepted Answer · 2020-10-28 07:03:46Z

0

Try wrapping your depCodes in additional quotes

const deptCodes = ["'001'", "'002'", "'003'"]

or

const deptCodes = ['\'001\'', '\'002\'', '\'003\'']

answered Oct 28, 2020 at 7:03

Anastasiia Solop

1,54314 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

How do I write a SELECT .. WHERE IN clause using NodesJS and Postgresql?

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