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 > >

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 f

Re: [GENERAL] Help with converting hexadecimal to decimal

2005-03-31 Thread Doug Quale
Bruce Momjian 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; >int4 >

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 r

[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