News for hackers. Stuff that matters.
Re:SQL language proposal: JOIN FOREIGN by mritchie712 on Thursday December 30, 2021 @01:51PM (#29739935)
yeah, this saves like 10 characters of text in exchange for massive confusion.
Re:SQL language proposal: JOIN FOREIGN by JoelJacobson on Thursday December 30, 2021 @01:55PM (#29739979)
In this simple example yes, but there can be multiple columns in a join.

The syntax proposal i O(1) syntax wise compared to O(2n) for a JOIN ON where n is the number of columns.

Re:SQL language proposal: JOIN FOREIGN by hn_throwaway_99 on Thursday December 30, 2021 @02:08PM (#29740157)
But that "simple example" is like 95% plus of all my joins, where I'm joining two tables on a foreign key.
Re:SQL language proposal: JOIN FOREIGN by JoelJacobson on Thursday December 30, 2021 @02:15PM (#29740238)
Your data model must be a lot simpler than mine, congrats ;)