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.
OpenPGP key available from http://romana.hajhouse.org/hajhouse.asc
In response to
pgsql-novice by date
|Next:||From: Peter Alberer||Date: 2001-07-24 13:55:38|
|Subject: View with parameters ?|
|Previous:||From: Robby Slaughter||Date: 2001-07-18 19:58:52|
|Subject: RE: Is there unsigned datatype in PostgreSQL?|