Just wondering: Is this a known 'feature' & is there a workaround (to catch the overflow and abort the txn)??:
www=# select bigint '9223372036854775807' - bigint '-9223372036854775807';
?column?
----------
-2
(1 row)
PostgreSQL 7.1.3 just downloaded.
Allan.
Use NUMERIC if you're concerned about overflow. The integer datatypes
are just C integers, and C doesn't provide any reasonable way to detect
overflow in integer arithmetic...
regards, tom lane
Есть вопросы? Напишите нам!
Соглашаюсь с условиями обработки персональных данных
✖
By continuing to browse this website, you agree to the use of cookies. Go to Privacy Policy.