From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
---|---|
To: | Lewis Christie <lewis(dot)christie(at)gmail(dot)com> |
Cc: | pgsql-docs(at)postgresql(dot)org |
Subject: | Re: Numeric Type Serial Range |
Date: | 2015-11-04 06:24:25 |
Message-ID: | CAB7nPqTQZXS_pFBJRC0rNuFzvWq2SBoftVwQn_g9YRbHWMGqQw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
On Tue, Nov 3, 2015 at 12:28 PM, Lewis Christie <lewis(dot)christie(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Gustafsson | 2015-11-09 22:40:27 | Documentation on Streaming Replication interface for Logical Decoding |
Previous Message | Tair Sabirgaliev | 2015-11-04 03:15:23 | Re: Moving documentation to XML |