Re: PRIMARY KEY and UNIQUE - Mailing list pgsql-general

--- Erwin Ambrosch <ambre@ebutec.com> wrote:
> Hi,
>
> I have a such a table.
>
> CREATE TABLE int_article (
>   name          VARCHAR(12) UNIQUE
>   headline      TEXT,
>   summary      TEXT,
>   main            TEXT,
>   footer           TEXT,
>   PRIMARY KEY (name)
> );
>
> Is the UNIQUE constraint neccessary, because if have
> specified the column
> name to be the primary key.
>
> Thanks in advance
> Erwin

No; but if you eliminate 'UNIQUE', you'll need to
replace it with 'NOT NULL'.

Andrew Gould


__________________________________________________
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com