Rejection of the smallest int8

From: sugita(at)sra(dot)co(dot)jp
To: pgsql-patches(at)postgresql(dot)org
Subject: Rejection of the smallest int8
Date: 2001-11-21 05:50:28
Message-ID: 20011121.145028.102774854.sugita@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-hackers pgsql-patches

Attached is a patch to accept the smallest value of int8.

The smallest value -9223372036854775808 is rejected as follows:

test=# create table test_int8 (val int8);
CREATE
test=# insert into test_int8 values (-9223372036854775807);
INSERT 4026531936 1
test=# insert into test_int8 values (-9223372036854775808);
ERROR: int8 value out of range: "-9223372036854775808"
test=#

Attachment Content-Type Size
unknown_filename text/plain 1.3 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-11-21 06:13:28 internals.ps
Previous Message Bruce Momjian 2001-11-21 05:41:49 Re: beta3

Browse pgsql-patches by date

  From Date Subject
Next Message Patrick Welche 2001-11-21 12:25:55 Re: [PATCHES] PQescapeBytea documentation patch
Previous Message Bruce Momjian 2001-11-21 05:45:59 Re: Chinese zh_CN NLS patches