On Wed, Dec 29, 2021, at 16:28, Tom Lane wrote: >Peter Eisentraut <peter.eisentr...@enterprisedb.com> writes: >> In the 1990s, there were some SQL drafts that included syntax like >> JOIN ... USING PRIMARY KEY | USING FOREIGN KEY | USING CONSTRAINT ... >> AFAICT, these ideas just faded away because of other priorities, so if >> someone wants to revive it, some work already exists. > > Interesting! One thing that bothered me about this whole line of > discussion is that we could get blindsided in future by the SQL > committee standardizing the same idea with slightly different > syntax/semantics. I think borrowing this draft text would greatly > improve the odds of that not happening. Do you have access to > full details?
Wisely said, I agree. I have access to the ISO online document database, but the oldest SQL documents I could find there are from 2008-10-15. I searched for document titles containing "SQL" in both ISO/IEC JTC 1/SC 32 and ISO/IEC JTC 1/SC 32/WG 3. It would be very interesting to read these old SQL drafts from the 1990s, if they can be found. /Joel