Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-sql-owner+M39292=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1dlrxC-00012J-Dr
	for pgsql-sql@arkaria.postgresql.org; Sun, 27 Aug 2017 07:25:54 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-sql-owner+M39292=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1dlrxB-0000si-Ja
	for pgsql-sql@arkaria.postgresql.org; Sun, 27 Aug 2017 07:25:53 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <andreas@a-kretschmer.de>)
	id 1dlrx9-0000qT-S1
	for pgsql-sql@postgresql.org; Sun, 27 Aug 2017 07:25:51 +0000
Received: from mailout01.ims-firmen.de ([213.174.32.96])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <andreas@a-kretschmer.de>)
	id 1dlrx6-0006tZ-R0
	for pgsql-sql@postgresql.org; Sun, 27 Aug 2017 07:25:51 +0000
Received: from mailin02.ims-firmen.de ([192.168.1.142])
	by mailout01.ims-firmen.de with esmtp
	(envelope-from <andreas@a-kretschmer.de>)
	id 1dlrx4-0002Rm-j6
	for pgsql-sql@postgresql.org; Sun, 27 Aug 2017 09:25:46 +0200
Received: from [79.204.155.253] (helo=[192.168.222.103])
	by mailin02.ims-firmen.de with esmtpa
	(envelope-from <andreas@a-kretschmer.de>)
	id 1dlrx4-000435-64
	for pgsql-sql@postgresql.org; Sun, 27 Aug 2017 09:25:46 +0200
Subject: Re: Hex to Number conversion
To: pgsql-sql@postgresql.org
References: <1503811739437-5980300.post@n3.nabble.com>
From: Andreas Kretschmer <andreas@a-kretschmer.de>
Message-ID: <7d3691eb-22f2-8a72-a900-ac957522e44d@a-kretschmer.de>
Date: Sun, 27 Aug 2017 09:25:46 +0200
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101
 Thunderbird/45.8.0
MIME-Version: 1.0
In-Reply-To: <1503811739437-5980300.post@n3.nabble.com>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 7bit
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@postgresql.org>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-sql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
X-Mailing-List: pgsql-sql
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org


Am 27.08.2017 um 07:28 schrieb anand086:
> How can I achieve the same in postgres.

test=*# select x'1fcd'::int;
  int4
------
  8141
(1 Zeile)


Regards, Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com



-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql