Re: next question, signed/unsigned - Mailing list pgsql-novice

From Josh Berkus
Subject Re: next question, signed/unsigned
Date
Msg-id 200304091203.43416.josh@agliodbs.com
Whole thread Raw
In response to next question, signed/unsigned  (Andy Harrison <ah59@httpsite.com>)
List pgsql-novice
Andy,

> postgres doesn't like unsigned at all.  I can't really find a reference to
> unsigned integers related to creating columns in the docs, so does this even
> apply?  Should I just tell them to ignore it in postgres?

Postgres does not support the "unsigned" keyword.

Should they need, for some reason, the functionality of an unsigned integer,
you can always create a DOMAIN of int that does not permit values < 0.

But in either case, you'll need to modify the CREATE TABLE statements.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


pgsql-novice by date:

Previous
From: Andy Harrison
Date:
Subject: next question, signed/unsigned
Next
From: "paul butler"
Date:
Subject: permission rejected