Thread: Numeric Type Serial Range

Numeric Type Serial Range

From

Lewis Christie

Date:

04 November 2015, 01:41:11

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.

serial 4 bytes autoincrementing integer 1 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

Re: Numeric Type Serial Range

From

Michael Paquier

Date:

04 November 2015, 09:24:30

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.
serial 4 bytes autoincrementing integer 1 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