Re: Is there unsigned datatype in PostgreSQL? - Mailing list pgsql-novice

From Henry House
Subject Re: Is there unsigned datatype in PostgreSQL?
Date
Msg-id 20010718183822.A21783@houseag.com
Whole thread Raw
In response to Is there unsigned datatype in PostgreSQL?  (Carfield Yim <mailing@desktop.carfield.com.hk>)
List 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

Attachment

pgsql-novice by date:

Previous
From: "Robby Slaughter"
Date:
Subject: RE: Is there unsigned datatype in PostgreSQL?
Next
From: "Leandro Fanzone"
Date:
Subject: ANSI SQL