Re: apply outer->inner join optimisation to OR clauses

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bradley Baetz <bbaetz(at)acm(dot)org>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: apply outer->inner join optimisation to OR clauses
Date: 2003-05-03 17:22:11
Message-ID: 15308.1051982531@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Bradley Baetz <bbaetz(at)acm(dot)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

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2003-05-03 17:28:45 Re: contrib/tablefunc bugfix
Previous Message Joe Conway 2003-05-03 15:06:57 contrib/tablefunc bugfix