Numeric Type Serial Range

From: Lewis Christie <lewis(dot)christie(at)gmail(dot)com>
To: pgsql-docs(at)postgresql(dot)org
Subject: Numeric Type Serial Range
Date: 2015-11-03 03:28:32
Message-ID: CAJT6SFFkv9-7+Msv-A-cUu2qSyOkX6YCUhijF56Hd+ZR1oyJfg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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

Tested on 9.3.10.

Regards,
Lewis Christie

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Alexander Lakhin 2015-11-03 10:48:17 Suspicious description of track_io_timing
Previous Message Stefan Kaltenbrunner 2015-11-02 20:15:46 Re: Moving documentation to XML