Re: Int8 problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "admin" <admin(at)mmelectrica(dot)ro>
Cc: "Jerome Raupach" <jraupach(at)intelcom(dot)fr>, pgsql-general(at)postgresql(dot)org
Subject: Re: Int8 problem
Date: 2000-09-27 06:43:22
Message-ID: 5937.970037002@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"admin" <admin(at)mmelectrica(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message gb 2000-09-27 06:57:08 Tablenames in Resultsets?
Previous Message admin 2000-09-27 06:18:32 Re: Int8 problem