Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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;
> int4
> ------
> 16
> (1 row)
That's not the inverse of to_hex(). to_hex() takes an integer and
returns text. You've taken the bitstring constant B'10000' and
coerced it to integer. The inverse funtion would take the text '10'
and return the integer 16.