Re: sequence skips 30 values, how? - Mailing list pgsql-general

DelGurth <delgurth@gmail.com> writes:
> Slightly OT. That documentation page of postgresql contains an invalid
> example. Not sure if I should report it in here, but well, there you
> go.

> CREATE SEQUENCE serial START 101;
> SELECT nextval('serial');
>  nextval
> ---------
>      114

> So you start at 101 and get 114, how nice ;-)

I think the assumption is that some time has passed (and some use of the
sequence) in between those steps.

            regards, tom lane