bigint overflow 'feature' - Mailing list pgsql-general

From Allan Engelhardt
Subject bigint overflow 'feature'
Date
Msg-id 3BABB58E.645D3EBF@cybaea.com
Whole thread Raw
Responses Re: bigint overflow 'feature'
List 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.

pgsql-general by date:

Previous
From: "Nick Fankhauser"
Date:
Subject: Re: connection fails
Next
From: Tom Lane
Date:
Subject: Re: bigint overflow 'feature'