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