Sorry, I did wrong test. > > > Noah Misch <n...@leadboat.com> writes: > > > > If the attached patch version looks reasonable, I will commit it. > > > > > > The test case is completely bogus, as the query explained is significantly > > > different from the query executed. I'm not sure whether you can just > > > remove the extra ORDER BY column without getting machine-dependent > > > results, though. > > > > Each query tests something slightly different. The EXPLAIN verifies that we > > can MergeAppend given this query structure, and the plain SELECT verifies > > that > > any join tree contortions we made to achieve that do not change the answer. > > I think Tom said that the second query can yield the same result > even if the 2nd column in orderby is removed so the pertinence of > it seems doubtful. Actually the altered query gave me the same > result on my workset (CentOS6.5/x86-64).
No, no! It was actually returned a *different* result. I accidentially(?) added 'desc' to the '2'. Please forget it. regards, -- Kyotaro Horiguchi NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
