> -----Original Message----- > From: Andrew Dunstan [mailto:[EMAIL PROTECTED] > Sent: Friday, July 25, 2008 1:28 PM > To: Dann Corbit > Cc: Tom Lane; Ryan Bradetich; Gregory Stark; pgsql- > [EMAIL PROTECTED] > Subject: Re: [HACKERS] [RFC] Unsigned integer support. > > > > Dann Corbit wrote: > >> -----Original Message----- > >> From: Andrew Dunstan [mailto:[EMAIL PROTECTED] > >> Sent: Friday, July 25, 2008 1:11 PM > >> To: Dann Corbit > >> Cc: Tom Lane; Ryan Bradetich; Gregory Stark; pgsql- > >> [EMAIL PROTECTED] > >> 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. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
