Re: Returning String as Integer - Mailing list pgsql-sql

From Markus Schaber
Subject Re: Returning String as Integer
Date
Msg-id 445DB254.5060606@logix-tt.com
Whole thread Raw
In response to Re: Returning String as Integer  ("Ben K." <bkim@coe.tamu.edu>)
List 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


pgsql-sql by date:

Previous
From: PFC
Date:
Subject: Re: Most efficient way to hard-sort records
Next
From: "Ben K."
Date:
Subject: Re: Most efficient way to hard-sort records