From: | "Donald Kerr" <donald(dot)kerr(at)dkerr(dot)co(dot)uk> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Hex to Dec Conversion |
Date: | 2010-10-18 21:47:32 |
Message-ID: | 13D772956A774BD189329582C6ADE155@DELLM4500 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
My first post to the mailing list and I hope I am in the right place!
I am trying to convert from hex to decimal and can do that successfully
using the following code:
SELECT x'FF'::integer;
which outputs 255 and is exactly what I want.
I want to substitute the string in the code 'FF' for a column in the
database like so:
SELECT x'db_column'::integer FROM db_table;
but no matter the combinations I try, I cannot get it to work.
Thew data colum contains html color codes like "0099FF" and I want to
convert these to, in this case, "0 153 255".
The following code behaves well:
SELECT x'00'::integer || ' ' || x'99'::integer || ' ' || x'FF'::integer;
resulting in "0 153 255". All correct
I was hopeful that something similar to the following would work but I just
cannot get it to work despite trying various combinations.
SELECT x'substring(col,1,2)'::integer || ' ' ||
x'substring(col,3,2)'::integer || ' ' || x'substring(col,5,2)'::integer
I would much prefer to do this as part of the query rather than having to
create a function. There must be a way! :)
Any help would be very greatly apprecaited.
Regards,
Donald
From | Date | Subject | |
---|---|---|---|
Next Message | jr | 2010-10-18 23:54:17 | Re: Overriding local encoding defaults |
Previous Message | Thom Brown | 2010-10-18 20:24:03 | Re: database access |