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 по дате отправления