Re: [GENERAL] Int8 problem

2000-09-27 Thread admin
. But how could i compile the int8 corectly? - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "admin" <[EMAIL PROTECTED]> Cc: "Jerome Raupach" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: 27 septembrie 2000 08:43 Subjec

Re: [GENERAL] Int8 problem

2000-09-26 Thread Tom Lane
"admin" <[EMAIL PROTECTED]> 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 thi

Re: [GENERAL] Int8 problem

2000-09-26 Thread admin
ent: 26 septembrie 2000 14:48 Subject: Re: [GENERAL] Int8 problem > your number is truncated to the biggest int8 ( 2*10^10, I think). > try with 'numeric'. > > Jerome. > > > admin wrote: > > > > Hi > > I have intalled Postgres 7.0.2 on a Compaq Alp

Re: [GENERAL] Int8 problem

2000-09-26 Thread admin
- Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "admin" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: 26 septembrie 2000 16:31 Subject: Re: [GENERAL] Int8 problem I send you the outputs maybe you will find an answer. Than

[GENERAL] Int8 problem

2000-09-26 Thread admin
Hi I have intalled Postgres 7.0.2 on a Compaq Alpha with DigitalUnix. If I insert a bigger number like 10^13 in an int8 type field i'm getting no error messages, no warnings, but if I check the value inserted i receive totaly wrong number like 2543 If you have any suggestions please let