List:General Discussion« Previous MessageNext Message »
From:Simcha Younger Date:July 14 2011 8:07am
Subject:Re: query for twin primes
View as plain text  
On Wed, 13 Jul 2011 12:26:02 -0600
Elim Qiu <elim.qiu@stripped> 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 < 1000000?
> 
> In other words, how to get the list of yonger brother of the twin
> primes within certain bound?
> 

select prime.* from prime join prime as p2 on prime.pv+2=p2.pv where prime.oid <
1000000;

-- 
Simcha Younger <simcha@stripped>
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