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