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: 20010718183822.A21783@houseag.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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 http://romana.hajhouse.org/hajhouse.asc

In response to

Browse pgsql-novice by date

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