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

From Tom Lane
Subject Re: Foreign key joins revisited
Date
Msg-id 1918433.1640722257@sss.pgh.pa.us
Whole thread Raw
In response to Re: Foreign key joins revisited  (Vik Fearing <vik@postgresfriends.org>)
Responses Re: Foreign key joins revisited  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Vik Fearing <vik@postgresfriends.org> writes:
> On 12/28/21 8:26 PM, Joel Jacobson wrote:
>> Can with think of some other suitable reserved keyword?

> I don't particularly like this whole idea anyway, but if we're going to
> have it, I would suggest

>     JOIN ... USING KEY ...

That would read well, which is nice, but I wonder if it wouldn't induce
confusion.  You'd have to explain that it didn't work like standard
USING in the sense of merging the join-key columns.

... unless, of course, we wanted to make it do so.  Would that
be sane?  Which name (referenced or referencing column) would
the merged column have?

            regards, tom lane



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Foreign key joins revisited
Next
From: Matheus Alcantara
Date:
Subject: Re: [PROPOSAL] Make PSQLVAR on \getenv opitional