From: Bruno Wolff III <bruno@wolff.to>
To: Roger Mathis <traderx@gmx.ch>
Cc: pgsql-sql@postgresql.org
Subject: Re: signed/unsigned integers
Date: Thu, 29 Aug 2002 08:41:29 -0500
Message-ID: <20020829134129.GA9800@wolff.to> (raw)
In-Reply-To: <3d65fbf1$0$22439$5402220f@news.sunrise.ch>
References: <3d65fbf1$0$22439$5402220f@news.sunrise.ch>
On Fri, Aug 23, 2002 at 11:11:51 +0200,
Roger Mathis <traderx@gmx.ch> wrote:
> Hi
>
> Is it true, that I can't define unsigned integers in a table definition?
If the main issue is that there not be negative numbers, you can use a
constraint to enforce this. In 7.3 you can define a domain with the
constraint and use it similar to a type.
If you need 32-63 bits worth of information, then you can use bigint with
some performance penalty. If you need 64 bits or more of information,
then you might be able to use numeric with an even larger performance hit.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bruno@wolff.to, traderx@gmx.ch
Subject: Re: signed/unsigned integers
In-Reply-To: <20020829134129.GA9800@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox