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'-