Tom your right.
I take a detailed look at it and it fails exactly at 2^31 .
2^31-1 = 2147483647 --> 2147483647
2^31 = 2147483648 --> -2147483648
2^31+1= 2147483649 --> -2147483647
.....
10^10 --> 1410065408
10^12 --> -727379968
...
But how could i compile the int8 corectly?
- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "admin" <admin@mmelectrica.ro>
Cc: "Jerome Raupach" <jraupach@intelcom.fr>; <pgsql-general@postgresql.org>
Sent: 27 septembrie 2000 08:43
Subject: Re: [GENERAL] Int8 problem
> "admin" <admin@mmelectrica.ro> writes:
> > But on the alpha i got no error message no worning and inserts a wrong
> > number if the number is bigger than 10^13 .
>
> 10^13? But values > 2^31 work? Man, that's really weird ... I was
> expecting a failure at 2^31 if int8 wasn't compiled correctly.
> I can't think what might fail at 10^13. Ideas anyone?
>
> It might help to see an exact table of equivalences, ie, so much
> in, so much out.
>
> regards, tom lane