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,
Pennsylvania19073