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

Re: Is there unsigned datatype in PostgreSQL?

From: Henry House <hajhouse(at)houseag(dot)com>
To: Carfield Yim <mailing(at)desktop(dot)carfield(dot)com(dot)hk>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Is there unsigned datatype in PostgreSQL?
Date: 2001-07-19 01:38:22
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
On Thu, Jul 19, 2001 at 01:47:40AM +0800, Carfield Yim wrote:
> Is there unsigned datatype like unsigned int?

Oddly enough, no. If you are only interested in positive numbers, you could
use the function ABS() (absolute value) to convert numeric fields to positive
integers when you store them.

Also it is possible to add new data types to PostgreSQL using the C
interface, though the result will be non-portable.

Henry House
OpenPGP key available from

In response to

pgsql-novice by date

Next:From: Peter AlbererDate: 2001-07-24 13:55:38
Subject: View with parameters ?
Previous:From: Robby SlaughterDate: 2001-07-18 19:58:52
Subject: RE: Is there unsigned datatype in PostgreSQL?

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