Postgres Pro
Downloads
Home   >   mailing lists

Re: Numeric Type Serial Range - Mailing list pgsql-docs

From Michael Paquier
Subject Re: Numeric Type Serial Range
Date
Msg-id CAB7nPqTQZXS_pFBJRC0rNuFzvWq2SBoftVwQn_g9YRbHWMGqQw@mail.gmail.com
Whole thread Raw
In response to Numeric Type Serial Range  (Lewis Christie <lewis.christie@gmail.com>)
List pgsql-docs
Tree view


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

pgsql-docs by date:

Previous
From: Tair Sabirgaliev
Date:
Subject: Re: Moving documentation to XML
Next
From: Daniel Gustafsson
Date:
Subject: Documentation on Streaming Replication interface for Logical Decoding