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

From Tom Lane
Subject Re: How can I get a column INT4 to be UNSIGNED ?
Date
Msg-id 10976.1050449388@sss.pgh.pa.us
Whole thread Raw
In response to Re: How can I get a column INT4 to be UNSIGNED ?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Ron Johnson wrote:
>> 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

It's new for 7.4, though.

            regards, tom lane


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Help using pgfsck
Next
From: Lamar Owen
Date:
Subject: Re: Upgrade to Red Hat Linux 9 broke PostgreSQL