postgresql delete rows based on inner join of complex subqueries

Question

I am trying to delete the matching rows from two complex subqueries. I am using postgresql. Here is a sample code:

DELETE FROM complex_subquery1 as a
USING   complex_subquery2 as b
WHERE a.column1 = b.column2

I read here: PostgreSQL: delete rows returned by subquery that this is not really possible this way. Is there a shortcut for the case of deleting inner join?

Laurenz Albe · Accepted Answer · 2019-09-09 05:50:29Z

0

The normal way to do that is

DELETE FROM atable
USING complex_subquery1 as a,
      complex_subquery2 as b
WHERE a.column1 = b.column2
  AND a.column3 = atable.column4;

answered Sep 9, 2019 at 5:50

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

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

1 Answer 1