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 по дате отправления: