NodeJs using express and pg-promise for postgresql?

Question

I'm running NodeJS and pg-promise, and are trying to accomplish somethings like:

db.any('SELECT * FROM t_user WHERE email=$1 NOT(SELECT email FROM t_user WHERE id= $2)', [email, id])

[and error syntax 'NOT'][1]

how i can SELECT with WHERE NOT?

Answer 1

Could you try this.

db.any('SELECT * FROM t_user WHERE email=$1 AND NOT EXISTS(SELECT email FROM t_user WHERE id= $2)', [email, id])