Re: Foreign key joins revisited

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Foreign key joins revisited
Дата
Msg-id 1918433.1640722257@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Foreign key joins revisited  (Vik Fearing <vik@postgresfriends.org>)
Ответы Re: Foreign key joins revisited  (Andrew Dunstan <andrew@dunslane.net>)
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Foreign key joins revisited
Следующее
От: Matheus Alcantara
Дата:
Сообщение: Re: [PROPOSAL] Make PSQLVAR on \getenv opitional