Re: apply outer->inner join optimisation to OR clauses - Mailing list pgsql-patches

From Tom Lane
Subject Re: apply outer->inner join optimisation to OR clauses
Date
Msg-id 15308.1051982531@sss.pgh.pa.us
Whole thread Raw
In response to apply outer->inner join optimisation to OR clauses  (Bradley Baetz <bbaetz@acm.org>)
Responses Re: apply outer->inner join optimisation to OR clauses  (Bradley Baetz <bbaetz@acm.org>)
List pgsql-patches
Bradley Baetz <bbaetz@acm.org> writes:
> The attached patch applies the optimisation translating outer joins to
> inner joins (where safe) to the cases where the WHERE clause has OR bits
> in it too, if the column is present (and not null) in all of the OR
> bits.

Your change for AND is obviously incorrect, and I don't think I believe
the OR case either.  Why is it safe to pass down a TRUE top_level flag?

            regards, tom lane


pgsql-patches by date:

Previous
From: Joe Conway
Date:
Subject: contrib/tablefunc bugfix
Next
From: Tom Lane
Date:
Subject: Re: contrib/tablefunc bugfix