"Gregory Stark" <[EMAIL PROTECTED]> writes: > "Tom Lane" <[EMAIL PROTECTED]> writes: > >> row-ordering discrepancy in rowtypes test | >> 2007-02-10 03:00:02 | 3 > > Is this because the test is fixed or unfixable? If not shouldn't the test get > an ORDER BY clause so that it will reliably pass on future versions?
Hm, I took a quick look at this test and while there are a couple tests missing ORDER BY clauses I can't see how they could possibly generate results that are out of order. Perhaps the ones that do have ORDER BY clauses only recently acquired them? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match