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------------------499602d2499602d24fa83d1136d920ef2e1b71785c8e11c53ff4c2824860fb8However, for some records, the original data is too large for casting.ERROR: value "14481874327766585215" is out of range for type bigintAny idea how to overcome this? to_hex function only accepts int or bigint.Thanks!--Regards,
Ang Wei Shan
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 по дате отправления: