List:General Discussion« Previous MessageNext Message »
From:Elim Qiu Date:July 13 2011 6:26pm
Subject:query for twin primes
View as plain text  
I have a prime table
+-----+------+---------+
| oid | pv   | descipt |
+-----+------+---------+
|   1 |    2 | NULL    |
|   2 |    3 | NULL    |
|   3 |    5 | NULL    |
|   4 |    7 | NULL    |
|   5 |   11 | NULL    |
|  .....................    |
+-----+------+---------+

what the query will be if i like to find all rows where pv+2's are
also in colum 'pv', where oid < 1000000?

In other words, how to get the list of yonger brother of the twin
primes within certain bound?

Thanks
Thread
query for twin primesElim Qiu13 Jul
  • Re: query for twin primesshawn wilson13 Jul
  • Re: query for twin primesmos13 Jul
    • Re: query for twin primesElim Qiu13 Jul
  • Re: query for twin primesSimcha Younger14 Jul