Re: [GENERAL] Help with converting hexadecimal to decimal

2005-04-01 Thread Dawid Kuroczko
On 31 Mar 2005 21:22:12 -0600, Doug Quale [EMAIL PROTECTED] wrote: I basically want to convert a a hexadecimal to a decimal. Sure: test= SELECT x'10'::integer; int4 -- 16 (1 row) Oh, some time ago I was looking for such a function and somehow

Re: [GENERAL] Help with converting hexadecimal to decimal

2005-04-01 Thread Chandra Sekhar Surapaneni
with converting hexadecimal to decimal On 31 Mar 2005 21:22:12 -0600, Doug Quale [EMAIL PROTECTED] wrote: I basically want to convert a a hexadecimal to a decimal. Sure: test= SELECT x'10'::integer; int4 -- 16 (1 row) Oh, some time ago I was looking

[GENERAL] Help with converting hexadecimal to decimal

2005-03-31 Thread Chandra Sekhar Surapaneni
Hi All, Is there a built in function which works exactly the opposite way as to_hex(). I basically want to convert a a hexadecimal to a decimal. Thanks ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Help with converting hexadecimal to decimal

2005-03-31 Thread Bruce Momjian
Chandra Sekhar Surapaneni wrote: Hi All, Is there a built in function which works exactly the opposite way as to_hex(). I basically want to convert a a hexadecimal to a decimal. Sure: test= SELECT x'10'::integer; int4 -- 16 (1 row)

Re: [GENERAL] Help with converting hexadecimal to decimal

2005-03-31 Thread Doug Quale
Bruce Momjian pgman@candle.pha.pa.us writes: Chandra Sekhar Surapaneni wrote: Hi All, Is there a built in function which works exactly the opposite way as to_hex(). I basically want to convert a a hexadecimal to a decimal. Sure: test= SELECT x'10'::integer;