Re: Foreign key joins revisited - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Foreign key joins revisited
Date
Msg-id 2030888.1640791702@sss.pgh.pa.us
Whole thread Raw
In response to Re: Foreign key joins revisited  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
Responses Re: Foreign key joins revisited  ("Joel Jacobson" <joel@compiler.org>)
Re: Foreign key joins revisited  ("Joel Jacobson" <joel@compiler.org>)
List pgsql-hackers
Peter Eisentraut <peter.eisentraut@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?

            regards, tom lane



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Foreign key joins revisited
Next
From: Tom Lane
Date:
Subject: Re: Report checkpoint progress in server logs