to_hex question - Mailing list pgsql-novice

Hi there,

Is there any easy way to get the decimal numeric value of a to_hex() function?
I have a table:

  info | a char(6) | b char(6)
---------+-----------+-----------
alpha    | 000001    | FFFFFF
beta     | 000002    | FFFFFE
...
and so on.

Now I really need the columns a and b in DECIMAL format instead of HEX. Where is the to_dec()
function? Do I have to create that myself?
I've been searching the archives but found no clue to this anywhere...

TIA

Allan Poulsen
SW. Development Engineer
Thrane & Thrane
Lundtoftegaardsvej 93D, DK-2800 Kgs. Lyngby, Denmark