Convert hex in text representation to decimal number
I am trying to convert hex to decimal using PostgreSQL 9.1 with this query: SELECT to_number('DEADBEEF', 'FMXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'); I get the following error: ERROR: inva...