From: | Adriaan Joubert <a(dot)joubert(at)albourne(dot)com> |
---|---|
To: | lockhart(at)fourpalms(dot)org |
Cc: | Postgresql <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | Re: int8 bug on Alpha |
Date: | 2001-03-21 13:10:55 |
Message-ID: | 3AB8A85F.7FC89E19@albourne.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Thomas Lockhart wrote:
>
> > int8 is not handled correctly on Alpha. Inserting 2^63-1, 2^63-2 and
> > 2^61...
>
> How are you doing the inserts? If you aren't coercing the "2" to be an
> int8, then (afaik) the math will be done in int4, then upconverted. So,
> can you confirm that your inserts look like:
>
> insert into lint values ('9223372036854775807');
OK, that was it. I inserted without quotes. If I insert the quotes it
works. So why does it work correctly on linux without quotes?
and
insert into lint values ('9223372036854775807'::int8);
works, but
insert into lint values (9223372036854775807::int8);
doesn't. I guess in the second case it converts it to an int4 and then
recasts to an int8?
Cheers,
Adriaan
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-03-21 13:25:00 | Re: Stuck spins in current |
Previous Message | sourabh dixit | 2001-03-21 11:50:02 | Re: PostgreSQL-JDBC driver |