Re: Help with text(decimal) to hex conversion

Поиск
Список
Период
Сортировка
От Szymon Lipiński
Тема Re: Help with text(decimal) to hex conversion
Дата
Msg-id CAFjNrYuXByBzJyaq0bNvhutcXx9AavAx_TP0WfXmeW--uCY=+Q@mail.gmail.com
обсуждение исходный текст
Ответ на Help with text(decimal) to hex conversion  (Wei Shan <weishan.ang@gmail.com>)
Список pgsql-novice
Дерево обсуждения


On 21 March 2016 at 09:30, Wei Shan <weishan.ang@gmail.com> wrote:
Hi all,

There's a column that has datatype of text. The conversion will work fine for some of the rows.

psql> select to_hex(data::bigint)from table limit 5;
      to_hex
------------------
 499602d2
 499602d2
 4fa83d1136d920ef
 2e1b71785c8e11c
 53ff4c2824860fb8


However, for some records, the original data is too large for casting.

ERROR:  value "14481874327766585215" is out of range for type bigint

Any idea how to overcome this? to_hex function only accepts int or bigint.

Thanks!
--
Regards,
Ang Wei Shan


Hi,
try this function:

create or replace function text_to_hex(t text) returns text as $$
return hex(int('14481874327766585215'))[2:-1]
$$ language plpythonu;

select text_to_hex('14481874327766585215');
   text_to_hex    
──────────────────
 c8f9f3f90c604f7f
(1 row)



--
    regards Szymon Lipiński

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

Предыдущее
От: Gavin Flower
Дата:
Сообщение: Re: Help with text(decimal) to hex conversion
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Help with text(decimal) to hex conversion