Re: signed/unsigned integers

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: signed/unsigned integers
Дата
Msg-id 20020829134129.GA9800@wolff.to
обсуждение исходный текст
Ответ на signed/unsigned integers  ("Roger Mathis" <traderx@gmx.ch>)
Список pgsql-sql
On Fri, Aug 23, 2002 at 11:11:51 +0200, Roger Mathis <traderx@gmx.ch> wrote:
> Hi
> 
> Is it true, that I can't define unsigned integers in a table definition?

If the main issue is that there not be negative numbers, you can use a
constraint to enforce this. In 7.3 you can define a domain with the
constraint and use it similar to a type.

If you need 32-63 bits worth of information, then you can use bigint with
some performance penalty. If you need 64 bits or more of information,
then you might be able to use numeric with an even larger performance hit.


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

Предыдущее
От: "Roger Mathis"
Дата:
Сообщение: signed/unsigned integers
Следующее
От: "Thomas F. O'Connell"
Дата:
Сообщение: the optimizer and exists