Skip site navigation (1) Skip section navigation (2)

Re: [RFC] Unsigned integer support.

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Dann Corbit <DCorbit(at)connx(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Ryan Bradetich <rbradetich(at)gmail(dot)com>, Gregory Stark <stark(at)enterprisedb(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [RFC] Unsigned integer support.
Date: 2008-07-25 20:28:10
Message-ID: 488A375A.1080405@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackers

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.

cheers

andrew

In response to

Responses

pgsql-hackers by date

Next:From: Dann CorbitDate: 2008-07-25 20:29:32
Subject: Re: [RFC] Unsigned integer support.
Previous:From: Ron MayerDate: 2008-07-25 20:18:47
Subject: Re: Do we really want to migrate plproxy and citext into PG core distribution?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group