Re: Returning String as Integer

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: "Ben K(dot)" <bkim(at)coe(dot)tamu(dot)edu>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Returning String as Integer
Date: 2006-05-07 08:39:48
Message-ID: 445DB254.5060606@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Ben K. 2006-05-07 14:16:41 Re: Most efficient way to hard-sort records
Previous Message PFC 2006-05-07 08:32:29 Re: Most efficient way to hard-sort records