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 <jdavis-pgsql@empires.org> 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,
Pennsylvania19073