public inbox for [email protected]  

help / color / mirror / Atom feed

Numeric Type Serial Range
2+ messages / 2 participants
[nested] [flat]

* Numeric Type Serial Range
@ 2015-11-03 03:28  Lewis Christie <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Lewis Christie @ 2015-11-03 03:28 UTC (permalink / raw)
  To: 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


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Numeric Type Serial Range
@ 2015-11-04 06:24  Michael Paquier <[email protected]>
  parent: Lewis Christie <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Michael Paquier @ 2015-11-04 06:24 UTC (permalink / raw)
  To: Lewis Christie <[email protected]>; +Cc: pgsql-docs

On Tue, Nov 3, 2015 at 12:28 PM, Lewis Christie <[email protected]>
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


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2015-11-04 06:24 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-11-03 03:28 Numeric Type Serial Range Lewis Christie <[email protected]>
2015-11-04 06:24 ` Michael Paquier <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox