Received: from news.tht.net (news.hub.org [216.126.91.242])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f3PMu0324466
	for <pgsql-docs@postgresql.org>; Wed, 25 Apr 2001 18:56:00 -0400 (EDT)
	(envelope-from news@news.tht.net)
Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id
 f3PMqdQ81914
	for pgsql-docs@postgresql.org; Wed, 25 Apr 2001 18:52:39 -0400 (EDT)
	(envelope-from news)
From: Mark Butler <butlerm@middle.net>
X-Newsgroups: comp.databases.postgresql.docs
Subject: Re: Are there unsigned int types in the manual
Date: Wed, 25 Apr 2001 16:52:42 -0600
Organization: Hub.Org Networking Services (http://www.hub.org)
Lines: 16
Message-ID: <3AE7553A.D8FCCD3F@middle.net>
References: <6154E048C16E7749ADD92922D2AD7D4008D2CC@BUFORD.littlefeet-inc.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Complaints-To: scrappy@hub.org
To: Mike Cianflone <mcianflone@littlefeet-inc.com>
X-Mailer: Mozilla 4.75 [en] (WinNT; U)
X-Accept-Language: en
To: pgsql-docs@postgresql.org
X-Archive-Number: 200104/79
X-Sequence-Number: 651

Mike Cianflone wrote:
> 
>         Is there somewhere in the manual that specifies if there is an
> unsigned int type for Postgressql. In an online manual I I see the int2,
> int4, and int8 types, but they are signed. I'm looking for an unsigned 2
> byte and 4 byte type that goes from 0 to 65535, and 0 to 4.2 billion,
> respectively. Are they specified anywhere?
> 
> Thanks,
> Mike

I am quite certain there are no such types in PostgreSQL, and that there
probably never will be.  Internally, Postgres uses an NxN type conversion
system that makes it difficult to add new primitive data types. 

 - Mark Butler