Re: next question, signed/unsigned

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: next question, signed/unsigned
Дата
Msg-id 200304091203.43416.josh@agliodbs.com
обсуждение исходный текст
Ответ на next question, signed/unsigned  (Andy Harrison <ah59@httpsite.com>)
Список 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 по дате отправления:

Предыдущее
От: Andy Harrison
Дата:
Сообщение: next question, signed/unsigned
Следующее
От: "paul butler"
Дата:
Сообщение: permission rejected