Re: [HACKERS] FW: [JDBC] BIGINT vs Java's long

2001-08-07 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > I don't think my patch against recent sources would apply cleanly to > older ones, and I didn't run the regression against it, but it seemed > to work, and is only a two line change in current source. This patch needs more work. You are assuming that

Re: [HACKERS] FW: [JDBC] BIGINT vs Java's long

2001-08-07 Thread Stephan Szabo
On Tue, 7 Aug 2001, Tom Lane wrote: > Stephan Szabo <[EMAIL PROTECTED]> writes: > > I don't think my patch against recent sources would apply cleanly to > > older ones, and I didn't run the regression against it, but it seemed > > to work, and is only a two line change in current source. > > Th

Re: [HACKERS] FW: [JDBC] BIGINT vs Java's long

2001-08-07 Thread Peter Eisentraut
Dave Cramer writes: > Apparently bigint is not really 8 bytes??? It's sort of 7.999 bytes. > test=# update testbigint set fp0 = -9223372036854775808 where id = 1; > ERROR: int8 value out of range: "-9223372036854775808" This is a bug in the int8 value parser. While it reads the string it alw

Re: [HACKERS] FW: [JDBC] BIGINT vs Java's long

2001-08-07 Thread Stephan Szabo
On Tue, 7 Aug 2001, Dave Cramer wrote: > This came into the jdbc list > > Apparently bigint is not really 8 bytes??? > > I test this out with psql > > test=# create table testbigint (id serial, fp0 int8); > NOTICE: CREATE TABLE will create implicit sequence 'testbigint_id_seq' > for SERIAL c

[HACKERS] FW: [JDBC] BIGINT vs Java's long

2001-08-07 Thread Dave Cramer
This came into the jdbc list Apparently bigint is not really 8 bytes??? I test this out with psql test=# create table testbigint (id serial, fp0 int8); NOTICE: CREATE TABLE will create implicit sequence 'testbigint_id_seq' for SERIAL column 'testbigint.id' NOTICE: CREATE TABLE/UNIQUE will cre