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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
