Re: Int8 problem - Mailing list pgsql-general

From Tom Lane
Subject Re: Int8 problem
Date
Msg-id 5937.970037002@sss.pgh.pa.us
Whole thread Raw
In response to Re: Int8 problem  ("admin" <admin@mmelectrica.ro>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: "admin"
Date:
Subject: Re: Int8 problem
Next
From: "admin"
Date:
Subject: Re: Int8 problem