Postgres Pro
Downloads
Home   >   mailing lists

Re: delete where not in another table - Mailing list pgsql-sql

From Igor Neyman
Subject Re: delete where not in another table
Date
Msg-id A76B25F2823E954C9E45E32FA49D70EC1BBDB24E@mail.corp.perceptron.com
Whole thread Raw
In response to delete where not in another table  ("Campbell, Lance" <lance@illinois.edu>)
Responses Re: delete where not in another table
List pgsql-sql
Tree view 
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Campbell, Lance
Sent: Tuesday, July 09, 2013 3:25 PM
To: pgsql-sql@postgresql.org
Subject: [SQL] delete where not in another table

 
DELETE FROM T1 WHERE T1.user_id NOT IN (SELECT user_id FROM T2 WHERE T2.user_id=T1.user_id);
 
Thanks,
 
Lance Campbell
Software Architect
Web Services at Public Affairs
217-333-0382

  --
Try:

DELETE  FROM t1   USING t2  WHERE t1.user_id != t2.user_id;

Test it before running on production db.

Regards,
Igor Neyman
 

pgsql-sql by date:

Previous
From: "Campbell, Lance"
Date:
Subject: delete where not in another table
Next
From: Huan Ruan
Date:
Subject: DateDiff() function