Skip site navigation (1) Skip section navigation (2)

Re: PRIMARY KEY on a *group* of columns imply that each column is NOT

From: Stephane Bortzmeyer <bortzmeyer(at)nic(dot)fr>
To: Sebastian Böck <sebastianboeck(at)freenet(dot)de>
Cc: Stephane Bortzmeyer <bortzmeyer(at)nic(dot)fr>,pgsql-general(at)postgresql(dot)org
Subject: Re: PRIMARY KEY on a *group* of columns imply that each column is NOT
Date: 2005-04-27 14:57:53
Message-ID: 20050427145753.GA2740@nic.fr (view raw or flat)
Thread:
Lists: pgsql-general
On Wed, Apr 27, 2005 at 04:50:23PM +0200,
 Sebastian Böck <sebastianboeck(at)freenet(dot)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".

In response to

Responses

pgsql-general by date

Next:From: Stephane BortzmeyerDate: 2005-04-27 15:00:17
Subject: Re: PRIMARY KEY on a *group* of columns imply that each column is NOT
Previous:From: Sebastian BöckDate: 2005-04-27 14:50:23
Subject: Re: PRIMARY KEY on a *group* of columns imply that each

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group