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

From Peter Eisentraut
Subject Re: Foreign key joins revisited
Date
Msg-id 15396c9b-ad78-4c68-7dcb-17d3b8ece972@enterprisedb.com
Whole thread Raw
In response to Re: Foreign key joins revisited  (Vik Fearing <vik@postgresfriends.org>)
Responses Re: Foreign key joins revisited
Re: Foreign key joins revisited
List pgsql-hackers
On 28.12.21 20:45, Vik Fearing wrote:
> I don't particularly like this whole idea anyway, but if we're going to
> have it, I would suggest
> 
>      JOIN ... USING KEY ...
> 
> since USING currently requires a parenthesized list, that shouldn't
> create any ambiguity.

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.




pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: psql - add SHOW_ALL_RESULTS option
Next
From: Peter Eisentraut
Date:
Subject: Re: Converting WAL to SQL