Re: How to Shuffle data

2011-07-14 Thread Hal�sz S�ndor
2011/07/13 19:28 +0530, Adarsh Sharma I think a procedure can do it easily , If I know the proper function for that. Well, here is a procedure that copies from one table, strips off the leading slash-separated part and reverses it by dots, and inserts the original, the reversed

Re: How to Shuffle data

2011-07-14 Thread shawn wilson
On Thu, Jul 14, 2011 at 10:50, Jerry Schwartz wrote: > There are a couple of problems with using any database for doing this. > you're probably right. that said > - Rows in a table are inherently in no particular order. That means they are > neither sorted nor random. > - Depending upon the

RE: How to Shuffle data

2011-07-14 Thread Jerry Schwartz
There are a couple of problems with using any database for doing this. - Rows in a table are inherently in no particular order. That means they are neither sorted nor random. - Depending upon the keys you are using (an auto-increment field for example), you might be able to select a random row;

Re: query for twin primes

2011-07-14 Thread Simcha Younger
On Wed, 13 Jul 2011 12:26:02 -0600 Elim Qiu wrote: > I have a prime table > > what the query will be if i like to find all rows where pv+2's are > also in colum 'pv', where oid < 100? > > In other words, how to get the list of yonger brother of the twin > primes within certain bound? > se