Re: Foreign key joins revisited

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