From: | Klemens Eisenstecken <klemens(dot)eisenstecken(at)gmail(dot)com> |
---|---|
To: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
Cc: | pgsql-docs(at)postgresql(dot)org |
Subject: | Re: CREATE SEQUENCE minvalue for descending sequence |
Date: | 2017-08-18 13:28:12 |
Message-ID: | CACYg4J2btsv+mz9rWFSQO19m6uahNVOGzYzbiJEhnimghrQoWw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
Thank you for the clarification!
Michael Paquier <michael(dot)paquier(at)gmail(dot)com> schrieb am Do., 17. Aug. 2017
um 04:14 Uhr:
> On Wed, Aug 16, 2017 at 10:00 PM, Klemens Eisenstecken
> <klemens(dot)eisenstecken(at)gmail(dot)com> wrote:
> > Hello,
> >
> > while reading your documentation about create sequence I found that you
> > mention the minvalue for a descending sequence is -2^63-1.
> >
> > But as far as I know the minvalue of long is -2^63+1.
> >
> > The mentioned documentation is at:
> > https://www.postgresql.org/docs/9.6/static/sql-createsequence.html
>
> Logically the minimum value of long is -2^63, the maximum being 2^63 -
> 1, but as you say the default minvalue of a descending sequence is
> -2^63 + 1, so the docs are wrong. Note that Postgres has changed this
> idiotic minimal value behavior in 10, using now the real minimum value
> of the types used with a sequence.
> --
> Michael
>
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Gustafsson | 2017-08-18 13:37:51 | Re: Default names for CRL and CA files in the backend |
Previous Message | Michael Paquier | 2017-08-18 07:28:21 | Re: Default names for CRL and CA files in the backend |