Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 2D41C632410 for ; Tue, 22 Jun 2010 05:28:02 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 84275-03 for ; Tue, 22 Jun 2010 08:27:54 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-px0-f174.google.com (mail-px0-f174.google.com [209.85.212.174]) by mail.postgresql.org (Postfix) with ESMTP id 0E912632283 for ; Tue, 22 Jun 2010 05:27:54 -0300 (ADT) Received: by pxi12 with SMTP id 12so1852026pxi.19 for ; Tue, 22 Jun 2010 01:27:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:subject:content-type :content-transfer-encoding; bh=fbFsa8xejRr2ETnVRK8X2Wbd/Eiu5MAwlNnbY74P3es=; b=Zde0oja5TNfw8PzI7W1aA7Ii8cXPyd1psVieuGwZLxDOQG4NFx3e05+BCD07DBoT4p QUhwBlIGyjPgIW7druUVPfYxw2oJTwPQY2hNb48On6JW7tv9pKu+GSonBp+vRf/RvHEn g1HP3fIkfLMFk37oFlLET/8M3fLuUKT7piGRA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:subject :content-type:content-transfer-encoding; b=Hwm+fhA0wusComob/8JuVFUcD1vQeWFaN7wKucgedQUu5t/sFEGs9fieMfrsKU9eFo q7REBNFmHlHYtsp9Qsz0F61zUuR4gO94yP7pF/bhnHTCZqixVXHWM7WhGq8nVUQRaAjw xMPSy2yU2wfW2uuxUCENjRWwhR39WyjXV+R40= Received: by 10.115.117.40 with SMTP id u40mr5211004wam.202.1277195266138; Tue, 22 Jun 2010 01:27:46 -0700 (PDT) Received: from [10.0.2.101] ([121.2.69.237]) by mx.google.com with ESMTPS id d20sm62965928waa.3.2010.06.22.01.27.44 (version=TLSv1/SSLv3 cipher=RC4-MD5); Tue, 22 Jun 2010 01:27:45 -0700 (PDT) Message-ID: <4C207403.3080103@gmail.com> Date: Tue, 22 Jun 2010 17:27:47 +0900 From: Satoshi Nagayasu User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; ja; rv:1.9.1.10) Gecko/20100512 Thunderbird/3.0.5 MIME-Version: 1.0 To: pgsql-docs@postgresql.org Subject: INTEGER range ("-2147483648" is not accepted.) Content-Type: text/plain; charset=ISO-2022-JP Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201006/43 X-Sequence-Number: 5611 Hi all, I've found a bit strange thing on the INTEGER range in the official manual. http://www.postgresql.org/docs/8.4/interactive/datatype-numeric.html According to the official manual, the INTEGER range is "-2147483648 to +2147483647". However, my example in below shows that "-2147483648" is not accepted. Is this correct? Any suggestions? Regards, --------------------------------------------------------------------- template1=# SELECT version(); version ------------------------------------------------------------------------------------------------------------ PostgreSQL 8.4.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20071124 (Red Hat 4.1.2-42), 32-bit (1 row) template1=# SELECT -2147483647::integer; ?column? ------------- -2147483647 (1 row) template1=# SELECT -2147483648::integer; ERROR: integer out of range template1=# SELECT +2147483648::integer; ERROR: integer out of range template1=# SELECT +2147483647::integer; ?column? ------------ 2147483647 (1 row) template1=# --------------------------------------------------------------------- -- NAGAYASU Satoshi