From: Sascha Ziemann <ziemann@secunet.de>
To: pgsql-sql@postgresql.org
Subject: UNIQUE constraint
Date: 06 Aug 2004 20:25:02 +0200
Message-ID: <m37jscdszl.fsf@sn-e0310.ek.secunet.de> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ziemann@secunet.de
Subject: Re: UNIQUE constraint
In-Reply-To: <m37jscdszl.fsf@sn-e0310.ek.secunet.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox