List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:October 5 1999 10:00pm
Subject:Re: Outputting Selects in Random Order
View as plain text  
At 14:50, 19991005, Hunter Hillegas wrote:
>Is there any way from something like 'SELECT * FROM RECORDS' would output
>the results in a random order, not by insertion order?

Check the mailing list for "random", there's been several discussions on
it.

A select does *not* happen in insertion order by default.  Please do not
depend on that in your programs, because they will certainly break.  You
can not count on any order back from a SELECT unless you specify one with
an ORDER BY clause!

Tim
Thread
A question about indexesMoz5 Oct
  • Re: A question about indexesBob Kline5 Oct
    • Outputting Selects in Random OrderHunter Hillegas5 Oct
      • Re: Outputting Selects in Random OrderThimble Smith6 Oct
      • Re: Outputting Selects in Random OrderBob Kline6 Oct
        • Re: Outputting Selects in Random OrderScott Hess6 Oct
          • Re: Outputting Selects in Random OrderThimble Smith6 Oct
          • Re: Outputting Selects in Random OrderBob Kline6 Oct
            • Re: Outputting Selects in Random OrderHunter Hillegas6 Oct
              • Re: Outputting Selects in Random OrderBob Kline6 Oct
                • Re: Outputting Selects in Random OrderMartin Ramsch7 Oct
    • Re: Outputting Selects in Random OrderHunter Hillegas6 Oct
Re: A question about indexesMark Papadakis5 Oct
  • Re: A question about indexesBob Kline6 Oct