From: Richard Huxton <dev@archonet.com>
To: Kaloyan Iliev Iliev <news1@faith.digsys.bg>,
	pgsql-sql@postgresql.org
Subject: Re: Unsigned numbers
Date: Wed, 26 Nov 2003 11:46:08 +0000
User-Agent: KMail/1.5
References: <3FC48A26.1090407@faith.digsys.bg>
In-Reply-To: <3FC48A26.1090407@faith.digsys.bg>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200311261146.08737.dev@archonet.com>

On Wednesday 26 November 2003 11:10, Kaloyan Iliev Iliev wrote:
> Hello Friends,
>
> I have the following questions.
> I have a lot of fields in my database that are int or float.
> The problem is that I need them to be only positive (unsigned) and the
> users try to insert sometimes negative.
[snip - problem is that errors give constraint name]

> Are there any unsigned data types like unsigned int or unsigned float.
> Can I make a domain or something like that (How exactly to add
> constraint to domain).
> I am using v7.3.2.

Adding CHECKs to domains is new for 7.4, I believe. There aren't any built-in 
unsigned types, although in theory you could write your own.

What I do is format my constraint names in a known way. So, a check on table 
foo, column bar might be called "foo_bar_positive" - then I can get the 
information I want from the constraint name.

-- 
  Richard Huxton
  Archonet Ltd