Re: (2^63 - 1)::bigint => out of range? (because of the doubleprecision) - Mailing list pgsql-general

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@aklaver.com