Re: Dumb question about serial's upper limit - Mailing list pgsql-general

CSN <cool_screen_name90001@yahoo.com> writes:
> If integer's range is -2147483648 to +2147483647, why
> is serial's range only 1 to 2147483647 instead of 1 to
> about 4294967294?

How are you going to stuff 4294967294 into an integer field, which as
you just stated has an upper limit of 2147483647?

If we had an unsigned int type, we could use it for serial and get
that result, but we do not.

            regards, tom lane