Re: why unsigned numbers don't exist ? - Mailing list pgsql-general

From jdassen@cistron.nl (J.H.M. Dassen (Ray))
Subject Re: why unsigned numbers don't exist ?
Date
Msg-id slrn9i1gs4.jks.jdassen@odin.cistron-office.nl
Whole thread Raw
In response to why unsigned numbers don't exist ?  (Julien Jehannet <Julien.Jehannet@SecurityKeepers.com>)
Responses Re: Re: why unsigned numbers don't exist ?  (Julien Jehannet <Julien.Jehannet@SecurityKeepers.com>)
List pgsql-general
Julien Jehannet <Julien.Jehannet@SecurityKeepers.com> wrote:
> I am newbie with PostgreSQL and I ask myself if it's possible to have
> unsigned numbers.

As far as I know, there is no separate data type for unsigned numbers, but
you can of course use CHECK constraints like

            age       INTEGER      CHECK (age >= 0),

(see http://www.ca.postgresql.org/docs/aw_pgsql_book/node132.html).

HTH,
Ray
--
Those who are willing to trade their liberty for security deserve neither.
    Benjamin Franklin

pgsql-general by date:

Previous
From: Nicolas Huillard
Date:
Subject: RE: PostgreSQL 7.1 and ORACLE 8.x
Next
From: Andrew Gould
Date:
Subject: Re: Re: postgresql.conf file