Re: Dumb question about serial's upper limit

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: Dumb question about serial's upper limit
Дата
Msg-id 20051011233026.GP23883@pervasive.com
обсуждение исходный текст
Ответ на Re: Dumb question about serial's upper limit  ("Dann Corbit" <DCorbit@connx.com>)
Список pgsql-general
On Mon, Oct 10, 2005 at 11:52:40PM -0700, Dann Corbit wrote:
> How about something like:
>
> CREATE DOMAIN unsigned_small AS smallint check (VALUE >= 0)
>
> CREATE DOMAIN unsigned_int AS integer check (VALUE >= 0)
>
> CREATE DOMAIN unsigned_big AS bigint check (VALUE >= 0)
>
> The objection might be that we lose one bit of field width.
> But the extra safety is probably worth it if you really need unsigned
> and want to avoid ambiguity.

Certainly. But I was more interested in the space. :P
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

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

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: PostgreSQL's bug tracker
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Dumb question about serial's upper limit