Bruce Momjian <[EMAIL PROTECTED]> writes:
> My quick question is that if we have a1=b1 and b1=c1, isn't the join
> sorted by a1, b1, and c1, and threfore we don't get more sorted plans?
That's not the issue. See, before the transitive-equality patch,
if you wrote
select * from a,b,c whe
> What I'm thinking of doing is truncating the recorded pathkeys of a path
> at the first sortkey that's not useful for either a higher-level
> mergejoin clause or the requested final output sort ordering. Then the
> logic inside add_path() wouldn't change, but it would only be considering
> usef