| From: | "Allan Poulsen" <alp(at)tt(dot)dk> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | to_hex question |
| Date: | 2004-03-05 10:47:21 |
| Message-ID: | c29m04$b86$1@sea.gmane.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2004-03-05 19:42:04 | Re: Postgresql.conf help |
| Previous Message | Brian OBrien | 2004-03-04 21:45:43 | create type question.... |