Re: [RFC] Unsigned integer support. - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: [RFC] Unsigned integer support.
Date
Msg-id 488A375A.1080405@dunslane.net
Whole thread Raw
In response to Re: [RFC] Unsigned integer support.  ("Dann Corbit" <DCorbit@connx.com>)
Responses Re: [RFC] Unsigned integer support.  ("Dann Corbit" <DCorbit@connx.com>)
List pgsql-hackers

Dann Corbit wrote:
>> -----Original Message-----
>> From: Andrew Dunstan [mailto:andrew@dunslane.net]
>> Sent: Friday, July 25, 2008 1:11 PM
>> To: Dann Corbit
>> Cc: Tom Lane; Ryan Bradetich; Gregory Stark; pgsql-
>> hackers@postgresql.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.

cheers

andrew


pgsql-hackers by date:

Previous
From: Ron Mayer
Date:
Subject: Re: Do we really want to migrate plproxy and citext into PG core distribution?
Next
From: "Dann Corbit"
Date:
Subject: Re: [RFC] Unsigned integer support.