Adding unsigned 256 bit integers

Поиск
Список
Период
Сортировка
От Olivier Lalonde
Тема Adding unsigned 256 bit integers
Дата
Msg-id CALwxDuETY1_jzBSQC+nR-uBY0eZHhH5poTMo0KCCi14Z4RtCtQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Adding unsigned 256 bit integers  (Andrew Dunstan <andrew@dunslane.net>)
Re: Adding unsigned 256 bit integers  (Craig Ringer <craig@2ndquadrant.com>)
Re: Adding unsigned 256 bit integers  ("ktm@rice.edu" <ktm@rice.edu>)
Список pgsql-hackers
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?

--
- Oli

Olivier Lalonde
http://www.syskall.com <-- connect with me!

Freelance web and Node.js engineer
Skype: o-lalonde

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [BUG FIX] Compare returned value by socket() against PGINVALID_SOCKET instead of < 0
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Get more from indices.