Re: How can I get a column INT4 to be UNSIGNED ?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How can I get a column INT4 to be UNSIGNED ?
Дата
Msg-id 13417.1050092688@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: How can I get a column INT4 to be UNSIGNED ?  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Ответы Re: How can I get a column INT4 to be UNSIGNED ?  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-general
Alvaro Herrera <alvherre@dcc.uchile.cl> writes:
> Is there a reason for not supporting unsigned types?

Other than "it's not in any SQL standard", you mean?

Right now I'd resist adding such types because the numeric type
resolution rules are already a hairy mess.  If we ever get those
straightened out to the point where unadorned constants are reliably
interpreted "the right way", we could take another look to see if
unsigned types could be added without plunging everything back into
chaos.  I wouldn't hold my breath for it though.

            regards, tom lane


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

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: medical image on postgreSQL?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump: NOTICE: ShmemAlloc: out of memory