Re: How can I get a column INT4 to be UNSIGNED ? - Mailing list pgsql-general

From scott.marlowe
Subject Re: How can I get a column INT4 to be UNSIGNED ?
Date
Msg-id Pine.LNX.4.33.0304111451160.3560-100000@css120.ihs.com
Whole thread Raw
In response to Re: How can I get a column INT4 to be UNSIGNED ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Case sensitive order by
Next
From: Mike Mascari
Date:
Subject: Re: pg_dump: NOTICE: ShmemAlloc: out of memory