Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-docs-owner+M8425=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1ZtrUl-00084u-Kg
 for pgsql-docs@arkaria.postgresql.org; Wed, 04 Nov 2015 06:24:31 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.84) (envelope-from
 <pgsql-docs-owner+M8425=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1ZtrUl-0000rE-1q
 for pgsql-docs@arkaria.postgresql.org; Wed, 04 Nov 2015 06:24:31 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
 (Exim 4.84) (envelope-from <michael.paquier@gmail.com>)
 id 1ZtrUk-0000qy-F5
 for pgsql-docs@postgresql.org; Wed, 04 Nov 2015 06:24:30 +0000
Received: from mail-qg0-x22f.google.com ([2607:f8b0:400d:c04::22f])
 by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
 (Exim 4.84) (envelope-from <michael.paquier@gmail.com>)
 id 1ZtrUh-0001YO-E8
 for pgsql-docs@postgresql.org; Wed, 04 Nov 2015 06:24:30 +0000
Received: by qgeo38 with SMTP id o38so33471832qge.0
 for <pgsql-docs@postgresql.org>; Tue, 03 Nov 2015 22:24:25 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=mime-version:in-reply-to:references:date:message-id:subject:from:to
 :cc:content-type;
 bh=Nx4gfAi3Llg87MQ8VUsDAtD1xmUK0ihdBa3PvQag5yc=;
 b=NBuXf9Knfj+gBtTNb3TevMzWTh0eUFI9V8kIxtzDlbRIoIH5sgeol19apAfQ1f5PUF
 EKBvxAnI5N4ngKckuSLVay+UZeCMzXoUg6oxYCweVlrNc4JL4nLnhGUsG4LwLqqzroK3
 5MzC0rCduwZeAi19VeiTPTxG6Wve4LscpEhR/JSkjvPxp2A9Elz9D8l4YPGPNVLVlkCm
 FvDhxbISVNYHCNso0drFlp9cua/RINcoi0wC9loHt3uBfQHdhZ7raPgQBZz4Moa5m5dH
 KGOvujPtjo9+QOlaMjNqrP84geb3Mbti5QjDowykHyrVADRf0M1+wYxuoaIEbwCR8aUU
 DFDw==
MIME-Version: 1.0
X-Received: by 10.140.93.1 with SMTP id c1mr41483095qge.59.1446618265539; Tue,
 03 Nov 2015 22:24:25 -0800 (PST)
Received: by 10.140.39.199 with HTTP; Tue, 3 Nov 2015 22:24:25 -0800 (PST)
In-Reply-To: 
 <CAJT6SFFkv9-7+Msv-A-cUu2qSyOkX6YCUhijF56Hd+ZR1oyJfg@mail.gmail.com>
References: 
 <CAJT6SFFkv9-7+Msv-A-cUu2qSyOkX6YCUhijF56Hd+ZR1oyJfg@mail.gmail.com>
Date: Wed, 4 Nov 2015 15:24:25 +0900
Message-ID: 
 <CAB7nPqTQZXS_pFBJRC0rNuFzvWq2SBoftVwQn_g9YRbHWMGqQw@mail.gmail.com>
Subject: Re: Numeric Type Serial Range
From: Michael Paquier <michael.paquier@gmail.com>
To: Lewis Christie <lewis.christie@gmail.com>
Cc: pgsql-docs@postgresql.org
Content-Type: multipart/alternative; boundary=001a113ab9a6d7e0010523b10f27
X-Pg-Spam-Score: -2.7 (--)
List-Archive: <http://archives.postgresql.org/pgsql-docs>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-docs.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@postgresql.org>
List-Post: <mailto:pgsql-docs@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-docs>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
X-Mailing-List: pgsql-docs
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

--001a113ab9a6d7e0010523b10f27
Content-Type: text/plain; charset=UTF-8

On Tue, Nov 3, 2015 at 12:28 PM, Lewis Christie <lewis.christie@gmail.com>
wrote:

> I believe the range listed in Table 8-2. Numeric Types
> http://www.postgresql.org/docs/9.3/static/datatype-numeric.html is
> incorrect for the serial types.
>
> E.g.
> serial4 bytesautoincrementing integer1 to 2147483647This describes the
> auto-incrementing behaviour, but in practice the range is -2147483648 to
> +2147483647 as the only restriction on the created column is NOT NULL.
>

I would believe that this refers to the default range of a serial column,
which begins at 1 once the table using it is declared.
-- 
Michael

--001a113ab9a6d7e0010523b10f27
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><br><div class=3D"gmail_extra"><br><div class=3D"gmail_quo=
te">On Tue, Nov 3, 2015 at 12:28 PM, Lewis Christie <span dir=3D"ltr">&lt;<=
a href=3D"mailto:lewis.christie@gmail.com" target=3D"_blank">lewis.christie=
@gmail.com</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote" style=
=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=
=3D"ltr">I believe the range listed in=C2=A0Table 8-2. Numeric Types<span s=
tyle=3D"color:rgb(0,0,0);font-family:verdana,sans-serif;font-size:12.16px;f=
ont-weight:bold;line-height:18.24px">=C2=A0</span><a href=3D"http://www.pos=
tgresql.org/docs/9.3/static/datatype-numeric.html" target=3D"_blank">http:/=
/www.postgresql.org/docs/9.3/static/datatype-numeric.html</a> is incorrect =
for the serial types.<div><br></div><div>E.g.</div><div><table style=3D"mar=
gin:2ex 0px 2ex 2ex;border-spacing:0px;border-collapse:collapse;border:2px =
solid rgb(167,198,223);color:rgb(0,0,0);font-family:verdana,sans-serif;font=
-size:12.16px;background-color:rgb(224,236,239)" border=3D"1"><tbody><tr><t=
d style=3D"border:1px solid rgb(167,198,223);padding:0.5ex;background-color=
:rgb(255,255,255)"><tt style=3D"font-size:1.3em">serial</tt></td><td style=
=3D"border:1px solid rgb(167,198,223);padding:0.5ex;background-color:rgb(25=
5,255,255)">4 bytes</td><td style=3D"border:1px solid rgb(167,198,223);padd=
ing:0.5ex;background-color:rgb(255,255,255)">autoincrementing integer</td><=
td style=3D"border:1px solid rgb(167,198,223);padding:0.5ex;background-colo=
r:rgb(255,255,255)">1 to <a href=3D"tel:2147483647" value=3D"+12147483647" =
target=3D"_blank">2147483647</a></td></tr></tbody></table>This describes th=
e auto-incrementing behaviour, but in practice the range is -<a href=3D"tel=
:2147483648" value=3D"+12147483648" target=3D"_blank">2147483648</a> to +21=
47483647 as the only restriction on the created column is NOT NULL.<br></di=
v></div>
</blockquote></div><br></div><div class=3D"gmail_extra">I would believe tha=
t this refers to the default range of a serial column, which begins at 1 on=
ce the table using it is declared.<br>-- <br><div class=3D"gmail_signature"=
>Michael<br></div>
</div></div>

--001a113ab9a6d7e0010523b10f27--