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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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