prerequisites of pull_up_sublinks

Поиск
Список
Период
Сортировка
От Andy Fan
Тема prerequisites of pull_up_sublinks
Дата
Msg-id CAKU4AWrmgivKLsrxQtgcyfMkgCTRh-AbLfyawQUzgQQgr_PCUQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: prerequisites of pull_up_sublinks
Список pgsql-hackers
Hi,

I'm reading the pull_up_sublinks, and find the below comments.

 * However, this optimization *only*
 * works at the top level of WHERE or a JOIN/ON clause, because we cannot
 * distinguish whether the ANY ought to return FALSE or NULL in cases
 * involving NULL inputs. Also, in an outer join's ON clause we can only
 * do this if the sublink is degenerate (ie, references only the nullable
 * side of the join).

I tried to write some SQLs but still can't understand the above comments. Any
help here?

--
Best Regards

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

Предыдущее
От: "tsunakawa.takay@fujitsu.com"
Дата:
Сообщение: RE: [bug?] Missed parallel safety checks, and wrong parallel safety
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Tiny update to pg_stat_statements documentation