Sorry, please disregard my ramblings. I thought it was a different question.
--------------------------------------------------------------------------- pgman wrote: > Jim C. Nasby wrote: > > On Fri, Feb 25, 2005 at 01:30:57PM -0500, Tom Lane wrote: > > > Jeff Davis <[EMAIL PROTECTED]> writes: > > > > I didn't consider that. Is there a reason the regression tests assume > > > > the results will be returned in a certain order (or a consistent order)? > > > > > > We use diff as the checking tool. > > > > Doesn't the SQL spec specifically state that the only time you'll get > > results in a deterministic order is if you use ORDER BY? Assuming > > otherwise seems a bad idea (though at least in the case of testing it > > makes the test more strenuous rather than less...) > > The only trick I can think of is to use SELECT ... INTO TEMPORARY tab > ... oRDER BY and then use COPY to dump the table. It will then dump in > the order of the ORDER BY. > > -- > Bruce Momjian | http://candle.pha.pa.us > pgman@candle.pha.pa.us | (610) 359-1001 > + If your life is a hard drive, | 13 Roberts Road > + Christ can be your backup. | Newtown Square, Pennsylvania 19073 -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
