Home > mailing lists

Help with text(decimal) to hex conversion - Mailing list pgsql-novice

From	Wei Shan
Subject	Help with text(decimal) to hex conversion
Date	March 21, 2016 10:29:56
Msg-id	CAFe9ZTqUDZ_COnMWBb_XqXV5dAYcKjppf5dHSHaRNuBdZEBtvA@mail.gmail.com Whole thread Raw
Responses	Re: Help with text(decimal) to hex conversion Re: Help with text(decimal) to hex conversion Re: Help with text(decimal) to hex conversion
List	pgsql-novice

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

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

From: Andreas Kretschmer
Date: 15 March 2016, 20:47:59
Subject: Re: Initial performance tuning question

From: JORGE MALDONADO
Date: 21 March 2016, 15:22:37
Subject: Upgrading to a major version