Re: Making Vars outer-join aware

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Making Vars outer-join aware
Дата
Msg-id 1515100.1657633061@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Making Vars outer-join aware  (Richard Guo <guofenglinux@gmail.com>)
Ответы Re: Making Vars outer-join aware  (Richard Guo <guofenglinux@gmail.com>)
Список pgsql-hackers
Richard Guo <guofenglinux@gmail.com> writes:
> Note that the evaluation of expression 'b.j + 1' now occurs below the
> outer join. Is this something we need to be concerned about?

It seems more formally correct to me, but perhaps somebody would
complain about possibly-useless expression evals.  We could likely
re-complicate the logic that inserts PHVs during pullup so that it
looks for Vars it can apply the nullingrels to.  Maybe there's an
opportunity to share code with flatten_join_alias_vars?

            regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Önder Kalacı
Дата:
Сообщение: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher
Следующее
От: Robert Haas
Дата:
Сообщение: Re: making relfilenodes 56 bits