Help with text(decimal) to hex conversion

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