to_hex question

Поиск
Список
Период
Сортировка
Искать
От
Allan Poulsen
Тема
to_hex question
Дата
Msg-id
c29m04$b86$1@sea.gmane.org
Список
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
В списке pgsql-novice по дате отправления
От: Dean Sheppard
Дата:
От: tully
Дата:
FAQ