Re: Adding unsigned 256 bit integers

On 04/10/2014 09:13 AM, Olivier Lalonde wrote:
> I was wondering if there would be any way to do the following in 
> PostgreSQL:
>
>     UPDATE cryptotable SET work = work + 'some big hexadecimal number'
>
> where work is an unsigned 256 bit integer. Right now my column is a 
> character varying(64) column (hexadecimal representation of the 
> number) but I would be happy to switch to another data type if it lets 
> me do the operation above.
>
> If it's not possible with vanilla PostgreSQL, are there extensions 
> that could help me?
>
>


The numeric type allows numbers with huge numbers of digits. I've used 
it to calculate fibonacci numbers thousands of digits long.

cheers

andrew