Re: PRIMARY KEY and UNIQUE

If it is a primary key then it will automatically be UNIQUE.

You do not need the unique next to the VARCHAR in this situation

Darren

On Thu, 14 Feb 2002, Erwin Ambrosch 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
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>