Re: unsigned int4

On Mon, 3 Apr 2000, Scott M Jackson wrote:

> Is there a way to specify an unsigned int, such that it would create
> an ERROR condition if a transaction were to attempt to cause a
> particular value to go negative.

CREATE TABLE... (
  ...
  colname INTEGER CHECK (colname > 0)
  ...
);

-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden