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

Re: [RFC] Unsigned integer support.

From: "Dann Corbit" <DCorbit(at)connx(dot)com>
To: "Andrew Dunstan" <andrew(at)dunslane(dot)net>
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:29:32
Message-ID: D425483C2C5C9F49B5B7A41F8944154701000FAE@postal.corporate.connx.com (view raw or flat)
Thread:
Lists: pgsql-hackers
> -----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.

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2008-07-25 20:31:26
Subject: Re: [PATCHES] odd output in restore mode
Previous:From: Andrew DunstanDate: 2008-07-25 20:28:10
Subject: Re: [RFC] Unsigned integer support.

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