Re: Is there unsigned datatype in PostgreSQL?

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