Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UC9Rq-0005Ql-3o for pgsql-docs@arkaria.postgresql.org; Sun, 03 Mar 2013 13:59:30 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UC9Rp-0002YG-Kw for pgsql-docs@arkaria.postgresql.org; Sun, 03 Mar 2013 13:59:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UC9Rp-0002YB-62 for pgsql-docs@postgresql.org; Sun, 03 Mar 2013 13:59:29 +0000 Received: from mout.gmx.net ([212.227.15.18]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UC9Rn-0003qT-BL for pgsql-docs@postgresql.org; Sun, 03 Mar 2013 13:59:28 +0000 Received: from mailout-de.gmx.net ([10.1.76.4]) by mrigmx.server.lan (mrigmx001) with ESMTP (Nemesis) id 0MfTEr-1UQe3R2Rvn-00P7TJ for ; Sun, 03 Mar 2013 14:59:26 +0100 Received: (qmail invoked by alias); 03 Mar 2013 13:59:26 -0000 Received: from pool-108-52-108-60.phlapa.fios.verizon.net (EHLO [192.168.1.5]) [108.52.108.60] by mail.gmx.net (mp004) with SMTP; 03 Mar 2013 14:59:26 +0100 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX1+oiVZ2tV6oXbVRO3IHfnWHOhzqMcVhHe2QoRavNE 1EOgcoMBA76E1E Message-ID: <1362319162.11571.4.camel@vanquo.pezone.net> Subject: Re: Slight discrepancy From: Peter Eisentraut To: Lyle Cc: pgsql-docs Date: Sun, 03 Mar 2013 08:59:22 -0500 In-Reply-To: <51317723.3050100@cosmicperl.com> References: <51317723.3050100@cosmicperl.com> Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.4.4-1 Mime-Version: 1.0 Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-Pg-Spam-Score: -2.5 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org On Sat, 2013-03-02 at 03:50 +0000, Lyle wrote: > Here: > http://www.postgresql.org/docs/9.2/static/datatype-numeric.html > > smallint 2 bytes small-range integer -32768 to +32767 > integer 4 bytes typical choice for integer -2147483648 to +2147483647 > bigint 8 bytes large-range integer -9223372036854775808 to > 9223372036854775807 > > > The bigint maximum positive number doesn't have the + prefix like the > others. Fair enough. Adjustment made. -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs