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

RE: Is there unsigned datatype in PostgreSQL?

From: "Robby Slaughter" <webmaster(at)robbyslaughter(dot)com>
To: "Carfield Yim" <mailing(at)desktop(dot)carfield(dot)com(dot)hk>, <pgsql-novice(at)postgresql(dot)org>
Subject: RE: Is there unsigned datatype in PostgreSQL?
Date: 2001-07-18 19:58:52
Message-ID: EPEHLKLEHAHLONFOKNHNMEAJDDAA.webmaster@robbyslaughter.com (view raw or flat)
Thread:
Lists: pgsql-novice
Carfield,

Nope, there's not a native data type which is unsigned.

You could use the OID datatype, but that would be inelegant
and not very portable.

You could also use the NUMERIC data type and just use the
minimal number of points of precision, but that would
be inelegant and slower.

You can use a character field CHAR(x) with the number
of digits you want.

You can always go up to he next biggest INTEGER type.
(Numbers larger than 32,768? Go to INT4. Larger than 2 billion?
Go to INT 8. Larger than 4 x 10 ^ 18? Uh...(what are you
counting again?)

You could also just change your supporting to code to automatically
subtract the smallest negative number so that you effectively
get only positives. 

HTH

-Robby

-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Carfield Yim
Sent: Wednesday, July 18, 2001 12:48 PM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] Is there unsigned datatype in PostgreSQL?


Is there unsigned datatype like unsigned int?

-- 



Carfield Yim, visit my homepage at http://www.carfield.com.hk


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly

In response to

pgsql-novice by date

Next:From: Henry HouseDate: 2001-07-19 01:38:22
Subject: Re: Is there unsigned datatype in PostgreSQL?
Previous:From: Carfield YimDate: 2001-07-18 17:47:40
Subject: Is there unsigned datatype in PostgreSQL?

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