News for hackers. Stuff that matters.

A comment on Relational is more than SQL. Parent comment

Re:Relational is more than SQL by dllthomas on Sunday September 17, 2023 @04:46PM (#37549137) 

    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.
[ Parent | on HN ]

There are no comments on this comment yet.