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

Ron Johnson wrote:
> On Fri, 2003-04-11 at 16:09, Dennis Gearon wrote:
> > If he wants the full range of an INT4 unsigned, he needs to go to INT8 with the
> > constraint you mentioned. The underlying col type of INT4 only supports HALF of
> > the range of an INT4 unsigned, in the positive domain, that is.
>
> When domains allow CHECK constraints, that would be simplified, wouldn't
> it?

I thought we did support it:

test=> CREATE DOMAIN unsigned AS int4 CHECK ( VALUE > 0);
CREATE DOMAIN

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073