X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id E52059FA42A for ; Sun, 7 May 2006 05:40:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 84571-03 for ; Sun, 7 May 2006 05:39:52 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.187]) by postgresql.org (Postfix) with ESMTP id 831AA9FA32D for ; Sun, 7 May 2006 05:39:52 -0300 (ADT) Received: from [84.157.49.165] (helo=lunix.schabi.de) by mrelayeu.kundenserver.de (node=mrelayeu0) with ESMTP (Nemesis), id 0MKwh2-1Fcenu1tqI-0003lH; Sun, 07 May 2006 10:39:50 +0200 Received: from [127.0.0.1] (localhost [127.0.0.1]) by lunix.schabi.de (Postfix) with ESMTP id A4F761E4086; Sun, 7 May 2006 10:39:48 +0200 (CEST) Message-ID: <445DB254.5060606@logix-tt.com> Date: Sun, 07 May 2006 10:39:48 +0200 From: Markus Schaber User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051017) X-Accept-Language: de-DE, de, en-us, en MIME-Version: 1.0 To: "Ben K." CC: pgsql-sql@postgresql.org Subject: Re: Returning String as Integer References: <18AE59788A3FC640A367E5652E664D8002093F0C@xmb-sjc-237.amer.cisco.com> <200605051852.19596.jgodoy@gmail.com> <20060506153916.GA3434@wolff.to> In-Reply-To: X-Enigmail-Version: 0.93.0.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Provags-ID: kundenserver.de abuse@kundenserver.de login:a9554655f07a4e401310f2acfb43f5bf X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/77 X-Sequence-Number: 25108 Hi, Ben, Ben K. schrieb: > I tried int8(id) but java didn't take it as Integer. (It took int8 as > something like Long.) Yes, and that's good, as PostgreSQL int8 and java long actually are the same datatype (64-bit signed two's-complement). PostgreSQL int4 and Java int are the same (32-bit), as well as int2 and short. HTH, Markus