"Shane Harrelson" <[EMAIL PROTECTED]> wrote: > I have a table that has the rows sorted by using a column which is filled > with values from random(*). > > Is there a PRAGMA or other API which allows me to set the "seed" used by > random(*) such that > I can reproduce the same random sequence each time? >
If you compile with -DSQLITE_TEST then the same seed is used every time and the sequence will be reproducible. You can also overload the RandomSeed() interface in the OS module. (The techniques for doing that are going to change in version 3.5, so anything you do there will not be portable moving forward.) Otherwise, no, there is no good way to set the seed for the PRNG. There is no pragma. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
