hexadecimal to decimal

From: "Claudio Lapidus" <clapidus(at)hotmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: hexadecimal to decimal
Date: 2003-07-30 19:16:23
Message-ID: BAY7-DAV18uvmqVE2Qb0000cbe2@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-patches

Hello,

I have an attribute in a table which stores hexadecimal numbers as a
two-character string, i.e. the attr definition is char(2). Now I need to
display these values in decimal, but I wasn´t able to find such a function.
So, is there a way to perform this conversion?

thanks
cl.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2003-07-30 19:25:18 Re: [SQL] ALTER TABLE ... DROP CONSTRAINT
Previous Message Michael Govorun 2003-07-30 19:05:32 Re: Don't removes/recycles WAL files at all

Browse pgsql-patches by date

  From Date Subject
Next Message Nic 2003-07-30 19:44:24 Re: JDBC stored procs doc patch
Previous Message Tom Lane 2003-07-30 19:03:48 Re: array expression NULL fix [was: [HACKERS] odd behavior/possible bug]