Re: query for twin primes

[Simcha Younger]

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>