Adding Serial Type
| От | David Pratt |
|---|---|
| Тема | Adding Serial Type |
| Дата | |
| Msg-id | BD5CCB8C-CF9D-11D9-AEE7-000A27B3B070@eastlink.ca обсуждение исходный текст |
| Ответ на | Re: add serial no ("Uwe C. Schroeder" <uwe@oss4u.com>) |
| Ответы |
Re: Adding Serial Type
Re: Adding Serial Type |
| Список | pgsql-admin |
Pretty basic question. Is it necessary to add NOT NULL or UNIQUE NOT
NULL to SERIAL or is this implicit and unnecessary?
ie.
CREATE TABLE new_table (
id SERIAL UNIQUE NOT NULL,
description TEXT NOT NULL
);
Or should I just use below because Serial type implies this.
CREATE TABLE new_table (
id SERIAL,
description TEXT NOT NULL
);
Regards,
David
В списке pgsql-admin по дате отправления: