From webmaster@cosmicperl.com Mon Jun 1 08:15:47 2026 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UBdTU-0004NH-HB for pgsql-docs@arkaria.postgresql.org; Sat, 02 Mar 2013 03:51:04 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UBdTT-0005Ok-T6 for pgsql-docs@arkaria.postgresql.org; Sat, 02 Mar 2013 03:51:03 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UBdTT-0005Oe-0z for pgsql-docs@postgresql.org; Sat, 02 Mar 2013 03:51:03 +0000 Received: from ns.cosmichost.co.uk ([213.133.65.196] helo=cosmichost.co.uk) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UBdTO-0002tN-9K for pgsql-docs@postgresql.org; Sat, 02 Mar 2013 03:51:02 +0000 Received: from [192.168.1.10] (unknown [78.86.207.240]) (Authenticated sender: cosmicperl) by cosmichost.co.uk (Postfix) with ESMTP id 1009E100069 for ; Sat, 2 Mar 2013 03:50:55 +0000 (GMT) Message-ID: <51317723.3050100@cosmicperl.com> Date: Sat, 02 Mar 2013 03:50:59 +0000 From: Lyle User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20130215 Thunderbird/17.0.3 MIME-Version: 1.0 To: pgsql-docs Subject: Slight discrepancy Content-Type: multipart/alternative; boundary="------------080803000502000503000803" X-Pg-Spam-Score: -1.9 (-) 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 This is a multi-part message in MIME format. --------------080803000502000503000803 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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. Lyle --------------080803000502000503000803 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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.


Lyle

--------------080803000502000503000803-- From peter_e@gmx.net Mon Jun 1 08:15:47 2026 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