Thank you for the clarification! Michael Paquier <michael.paqu...@gmail.com> schrieb am Do., 17. Aug. 2017 um 04:14 Uhr:
> On Wed, Aug 16, 2017 at 10:00 PM, Klemens Eisenstecken > <klemens.eisenstec...@gmail.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 >
