Re: idea for concurrent seqscans

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