bigint overflow 'feature'

From: Allan Engelhardt <allane(at)cybaea(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: bigint overflow 'feature'
Date: 2001-09-21 21:47:58
Message-ID: 3BABB58E.645D3EBF@cybaea.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-09-21 23:13:49 Re: bigint overflow 'feature'
Previous Message Nick Fankhauser 2001-09-21 21:32:54 Re: connection fails