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) -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]