Re: Dumb question about serial's upper limit

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Dumb question about serial's upper limit
Дата
Msg-id 8606.1128999543@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Dumb question about serial's upper limit  (CSN <cool_screen_name90001@yahoo.com>)
Ответы Re: Dumb question about serial's upper limit  (CSN <cool_screen_name90001@yahoo.com>)
Re: Dumb question about serial's upper limit  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: CSN
Дата:
Сообщение: Dumb question about serial's upper limit
Следующее
От: Terence
Дата:
Сообщение: Re: Oracle buys Innobase