4 ms·
WITH t AS (SELECT 1 x) SELECT x FROM t JOIN t u ...; That breaks if you fill in the ... with "ON t.x = u.x" because there are two columns called "x", but w
by dllthomas 3y ago
WITH t AS (SELECT 1 x)
SELECT x FROM t JOIN t u ...;
That breaks if you fill in the ... with "ON t.x = u.x" because there are two columns called "x", but works with "USING (x)" because they get collapsed into a single column. I think it makes sense to say those aren't fully equivalent.