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