int8 size

jose' soares <sferac@bo.nettuno.it>

From: Sferacarta Software <sferac@bo.nettuno.it>
To: pgsql-hackers@postgresql.org
Date: 1998-11-05T15:11:35Z
Lists: 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
--------------------
-9223372036854775808
 9223372036854774785
(2 rows)


-Jose'-