I just think of it as performing a subquery for every row of the main query.

		foldr on May 22, 2023 \| parent \| context \| favorite \| on: The many faces of DISTINCT in Postgres (2017) I just think of it as performing a subquery for every row of the main query.