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