Postgres Pro
Downloads
Home   >   mailing lists

Numeric Type Serial Range - Mailing list pgsql-docs

From Lewis Christie
Subject Numeric Type Serial Range
Date
Msg-id CAJT6SFFkv9-7+Msv-A-cUu2qSyOkX6YCUhijF56Hd+ZR1oyJfg@mail.gmail.com
Whole thread Raw
Responses Re: Numeric Type Serial Range
List pgsql-docs
Tree view
Hi,

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.

Tested on 9.3.10.

Regards,
Lewis Christie

pgsql-docs by date:

Previous
From: Dmitry Igrishin
Date:
Subject: Re: Moving documentation to XML
Next
From: Alexander Lakhin
Date:
Subject: Suspicious description of track_io_timing