Postgres Delete Full outer join

Question

I would like to delete all post that do not contain a relation to media.

My select statement looks like this:

select post.*
from post full outer join media m on post.id = m.post_id where m is null;

How would the delete statement look like to delete all entries in the post table that do not have an entry in media?

Gordon Linoff · Accepted Answer · 2020-07-24 11:18:33Z

2

Use NOT EXISTS:

delete from post p
    where not exists (select 1 from media m where p.id = m.post_id);

answered Jul 24, 2020 at 11:18

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

1 Answer 1