int8 size - Mailing list pgsql-hackers

From Sferacarta Software
Subject int8 size
Date
Msg-id 3674.981105@bo.nettuno.it
Whole thread Raw
List pgsql-hackers
Hi all,

I'm trying to guess the size of int8...

hygea=> insert into b values (9223372036854775296);
NOTICE:  Integer input '9223372036854775296' is out of range; promoted to float
ERROR:  Floating point conversion to int64 is out of range
hygea=> select * from b;                i8
-------------------
9223372036854775807
9223372036854774784
(2 rows)

hygea=> update b set i8=i8+1;
UPDATE 2
hygea=> select * from b;                 i8
--------------------
-92233720368547758089223372036854774785
(2 rows)


-Jose'-




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Open the flood gates...v6.4 is tag'd...
Next
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] Re: bug on aggregate function AVG()