Re: Foreign key joins revisited

On 12/28/21 15:10, Tom Lane wrote:
> 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?
>
>             



I agree this would cause confusion. I think your earlier suggestion of


   JOIN ... FOREIGN KEY ...


seems reasonable.


cheers


andrew


--
Andrew Dunstan
EDB: https://www.enterprisedb.com