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

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: How can I get a column INT4 to be UNSIGNED ?
Дата
Msg-id Pine.LNX.4.33.0304111451160.3560-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Re: How can I get a column INT4 to be UNSIGNED ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Fri, 11 Apr 2003, Tom Lane wrote:

> 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.

Actually, I think unsigned ints are mentioned all through the sql 92 docs,
but only as an underlying subtype, never as its own, isn't it?


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Case sensitive order by
Следующее
От: Mike Mascari
Дата:
Сообщение: Re: pg_dump: NOTICE: ShmemAlloc: out of memory