On 12/28/21 15:10, Tom Lane wrote: > Vik Fearing <v...@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
