On Jul 13, 2011 2:26 PM, "Elim Qiu" <[email protected]> wrote:
>
> 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?
>
... where ('pv' *2) = pv and old < 1000000
Untested (might be issues with my string vs number)
> In other words, how to get the list of yonger brother of the twin
> primes within certain bound?
>
