Re: prerequisites of pull_up_sublinks

2021-04-21 Thread Andy Fan
On Wed, Apr 21, 2021 at 4:37 PM David Rowley wrote: > On Wed, 21 Apr 2021 at 14:55, Andy Fan wrote: > > * 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 > >

Re: prerequisites of pull_up_sublinks

2021-04-21 Thread David Rowley
On Wed, 21 Apr 2021 at 14:55, Andy Fan wrote: > * 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