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 53ff4c2824860fb8However, 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
pgsql-novice by date:
Соглашаюсь с условиями обработки персональных данных