On 04/10/2014 09:13 AM, Olivier Lalonde wrote:

I was wondering if there would be any way to do the following inPostgreSQL:UPDATE cryptotable SET work = work + 'some big hexadecimal number'where work is an unsigned 256 bit integer. Right now my column is acharacter varying(64) column (hexadecimal representation of thenumber) but I would be happy to switch to another data type if it letsme do the operation above.If it's not possible with vanilla PostgreSQL, are there extensionsthat 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers