I have a PostgreSQL query that looks like this:
DELETE FROM x WHERE x.id NOT IN (SELECT x_id FROM y WHERE ...);
Is it possible for the
DELETE to see rows that weren't previously committed and visible to the
My intuition is that since the subquery is part of the overall statement, no data changes should be visible to the
DELETE that weren't already visible to the
SELECT. Is this correct?