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

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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073