Re: [RFC] Unsigned integer support.

> -----Original Message-----
> From: Andrew Dunstan [mailto:andrew(at)dunslane(dot)net]
> Sent: Friday, July 25, 2008 1:28 PM
> To: Dann Corbit
> Cc: Tom Lane; Ryan Bradetich; Gregory Stark; pgsql-
> hackers(at)postgresql(dot)org
> Subject: Re: [HACKERS] [RFC] Unsigned integer support.
>
>
>
> Dann Corbit wrote:
> >> -----Original Message-----
> >> From: Andrew Dunstan [mailto:andrew(at)dunslane(dot)net]
> >> Sent: Friday, July 25, 2008 1:11 PM
> >> To: Dann Corbit
> >> Cc: Tom Lane; Ryan Bradetich; Gregory Stark; pgsql-
> >> hackers(at)postgresql(dot)org
> >> Subject: Re: [HACKERS] [RFC] Unsigned integer support.
> >>
> >>
> >>
> >> Dann Corbit wrote:
> >>
> >>> CREATE DOMAIN usmallint AS SMALLINT CHECK(VALUE > 0);
> >>> CREATE DOMAIN uinteger AS INTEGER CHECK(VALUE > 0);
> >>> CREATE DOMAIN ubigint AS BIGINT CHECK(VALUE > 0);
> >>> CREATE DOMAIN unumeric AS NUMERIC CHECK(VALUE > 0);
> >>>
> >>>
> >>>
> >>>
> >> s/>/>=/g
> >>
> >
> > I turned off the default "option" to remove extra line breaks.
> > Future posts should not be quite as even and bletcherous.
> > God willing, and the crick don't rise.
> >
> >
>
> I suspect you're missing my point, namely that 0 should be an allowed
> value for unsigned types.

Quite right. The domains I created were really the 'natural numbers'
rather than unsigned types.