Re: why unsigned numbers don't exist ?

From: jdassen(at)cistron(dot)nl (J(dot)H(dot)M(dot) Dassen (Ray))
To: pgsql-general(at)postgresql(dot)org
Subject: Re: why unsigned numbers don't exist ?
Date: 2001-06-08 12:22:28
Message-ID: slrn9i1gs4.jks.jdassen@odin.cistron-office.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Julien Jehannet <Julien(dot)Jehannet(at)SecurityKeepers(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Gould 2001-06-08 12:30:31 Re: Re: postgresql.conf file
Previous Message Nicolas Huillard 2001-06-08 12:21:21 RE: PostgreSQL 7.1 and ORACLE 8.x