X-Original-To: pgsql-sql@postgresql.org Received: from matrix.gatewaynet.com (unknown [217.19.69.50]) by postgresql.org (Postfix) with ESMTP id 5E43B475F39 for ; Tue, 11 Mar 2003 03:05:37 -0500 (EST) Received: from matrix.gatewaynet.com (matrix.gatewaynet.com [217.19.69.50] (may be forged)) by matrix.gatewaynet.com (8.12.5/8.12.5) with ESMTP id h2BCDUIs023608; Tue, 11 Mar 2003 10:13:30 -0200 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.5/8.12.5/Submit) with ESMTP id h2BCDTgo023604; Tue, 11 Mar 2003 10:13:29 -0200 Date: Tue, 11 Mar 2003 10:13:28 -0200 (GMT+2) From: Achilleus Mantzios To: Joe Conway Cc: pgsql-sql@postgresql.org Subject: Re: Hex Integer Input In-Reply-To: <3E68CDF0.4040302@joeconway.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200303/260 X-Sequence-Number: 12300 On Fri, 7 Mar 2003, Joe Conway wrote: > Achilleus Mantzios wrote: > > Hi, is there a way to enter integer data by their HEX > > representation?? > > > > Is this what you want? > > regression=# select x'ffff'::int4; > int4 > ------- > 65535 > (1 row) Sure. Thanx. > > > Joe > -- ================================================================== Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel: +30-210-8981112 fax: +30-210-8981877 email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr