Re: Int8 problem

Hi,
I have intalled Postgres 7.0.2 recently on 3 normal PC with RedHat and
Slackware to try its behavior
but its working good.
int8 thakes number much bigger then 10^13.
And if the number is to big (about 10^19 ) it generate an error message
(ERROR: int8 value out of range: ...) and don't insert it into the table.
But on the alpha i got no error message no worning and inserts a wrong
number if the number is bigger than 10^13 .

regard Hanos Felix

----- Original Message -----
From: "Jerome Raupach" <jraupach(at)intelcom(dot)fr>
To: "admin" <admin(at)mmelectrica(dot)ro>
Sent: 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 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 me know.
> >
> > Thank any way.