public inbox for [email protected]
help / color / mirror / Atom feedFrom: Michael Paquier <[email protected]>
To: Lewis Christie <[email protected]>
Cc: [email protected]
Subject: Re: Numeric Type Serial Range
Date: Wed, 4 Nov 2015 15:24:25 +0900
Message-ID: <CAB7nPqTQZXS_pFBJRC0rNuFzvWq2SBoftVwQn_g9YRbHWMGqQw@mail.gmail.com> (raw)
In-Reply-To: <CAJT6SFFkv9-7+Msv-A-cUu2qSyOkX6YCUhijF56Hd+ZR1oyJfg@mail.gmail.com>
References: <CAJT6SFFkv9-7+Msv-A-cUu2qSyOkX6YCUhijF56Hd+ZR1oyJfg@mail.gmail.com>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>
On Tue, Nov 3, 2015 at 12:28 PM, Lewis Christie <[email protected]>
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
view thread (2+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Numeric Type Serial Range
In-Reply-To: <CAB7nPqTQZXS_pFBJRC0rNuFzvWq2SBoftVwQn_g9YRbHWMGqQw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox