Postgres Pro
Downloads
Home   >   mailing lists

Re: PRIMARY KEY on a *group* of columns imply that each column is NOT - Mailing list pgsql-general

From Stephane Bortzmeyer
Subject Re: PRIMARY KEY on a *group* of columns imply that each column is NOT
Date
Msg-id 20050427145753.GA2740@nic.fr
Whole thread Raw
In response to Re: PRIMARY KEY on a *group* of columns imply that each  (Sebastian Böck <sebastianboeck@freenet.de>)
Responses Re: PRIMARY KEY on a *group* of columns imply that each  (Sebastian Böck <sebastianboeck@freenet.de>)
List pgsql-general
Tree view 
On Wed, Apr 27, 2005 at 04:50:23PM +0200,
 Sebastian Böck <sebastianboeck@freenet.de> wrote
 a message of 48 lines which said:

> CREATE UNIQUE INDEX na ON x (name, address) WHERE address IS NULL;

No, because it prevents two tuples with the same value of "name".

pgsql-general by date:

Previous
From: mmiranda@americatel.com.sv
Date:
Subject: After insert trigger question
Next
From: Stephane Bortzmeyer
Date:
Subject: Re: PRIMARY KEY on a *group* of columns imply that each column is NOT