Create a WHERE OR IN postgres

Question

Right now I have the query

DELETE FROM connections
WHERE "user_b_id" IN
(SELECT "id"
FROM   "users"
WHERE  'dharness.student@gmail.com'="email")

But what I really want is

WHERE "user_b_id" OR "user_a_id" IN ...

But I can't figure out how to make that work. Is there an operator for this?

That's perfect! Thankyou! Should I post this as the answer, or will you? — Dylan Harness, Mar 03 '16 at 08:24

dnoeth · Accepted Answer · 2016-03-03T08:49:59.013

3

If users.email is unique you can write

WHERE (SELECT id FROM users 
       WHERE email = 'dharness.student@gmail.com') 
   IN (user_b_id , user_a_id)

edited Mar 03 '16 at 08:49

answered Mar 03 '16 at 08:25

dnoeth

This will fail when this `SELECT id FROM users WHERE email = 'dharness.student@gmail.com'` query returns more than one row. But practically that should never happen :) – Pரதீப் Mar 03 '16 at 08:38
@MotoGP: That's why I wrote *If users.id is unique* :-) – dnoeth Mar 03 '16 at 08:43
Even though ID is unique and Email is duplicated it will be a problem – Pரதீப் Mar 03 '16 at 08:47
@MotoGP: Yep, of course, I should change to *if users.email is unique*. – dnoeth Mar 03 '16 at 08:49
@MotoGP Thanks for your valuable feedback.do you have another one approach/query to get rid from this – Ankit Agrawal Mar 03 '16 at 09:39
@User `SELECT * FROM connections C JOIN "users" u ON c."user_b_id" = u.id OR c.user_a_id = u.id ` – Pரதீப் Mar 03 '16 at 10:40

1 Answers1