UNIQUE constraint - Mailing list pgsql-sql

From Sascha Ziemann
Subject UNIQUE constraint
Date
Msg-id m37jscdszl.fsf@sn-e0310.ek.secunet.de
Whole thread Raw
Responses Re: UNIQUE constraint
List pgsql-sql
Hi,

I have a question about the UNIQUE constraint.  The documentation
describes this example:

CREATE TABLE example (   a integer,   b integer,   c integer,   UNIQUE (a, c)
);

But it is not clean to me.  Does the above example mean that the list
of pairs must be unique or is it only a short version for this
constraint:

CREATE TABLE example (   a integer UNIQUE,   b integer,   c integer UNIQUE
);

Does the following table fullfill the UNIQUE clause of the example
from the Postgres documentation?
 a b c ----- 1 2 3 1 1 1

cu Sascha

-- 
secunet Security Networks AG, Im Teelbruch 116, 45219 Essen
Tel: +49-2054-123-408   Fax: +49-2054-123-123
PGP: FBE2 A49B 6526 C1B4 7F10  24E4 5004 7C27 6E9A 9698



pgsql-sql by date:

Previous
From: "Thomas Wegner"
Date:
Subject: Re: Make a column case insensitive
Next
From: "Knut P Lehre"
Date:
Subject: select