On 06/08/2018 10:23 AM, Alexey Dokuchaev wrote:
Hi there,
P.S. On a tangentally related note, why is "NO CYCLE" is the default
for sequences?
[*] Per documentation, "The [SQL] standard's AS <data type> expression
is not supported." Another "why is it so?" question, btw. ;-)
I found it. Its in the docs for 9.6-. That is not the case anymore in 10+:
https://www.postgresql.org/docs/10/static/sql-createsequence.html
"data_type
The optional clause AS data_type specifies the data type of the
sequence. Valid types are smallint, integer, and bigint. bigint is the
default. The data type determines the default minimum and maximum values
of the sequence.
"
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
