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--