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