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

From: Stephane Bortzmeyer <bortzmeyer(at)nic(dot)fr>
To: Patrick TJ McPhee <ptjm(at)interlog(dot)com>
Cc: 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:06:32
Message-ID: 20050427140632.GA29093@nic.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Apr 27, 2005 at 05:19:32AM +0000,
Patrick TJ McPhee <ptjm(at)interlog(dot)com> wrote
a message of 37 lines which said:

> but you should know that in SQL, unique constraints don't apply to
> rows containing null values

May be I should but I didn't.

> your table definition will be as you want it, but the constraint you
> want won't be there.

OK, I will try to write a custom trigger, then.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-04-27 14:26:30 Re: PRIMARY KEY on a *group* of columns imply that each column is NOT
Previous Message Stephan Szabo 2005-04-27 13:54:57 Re: PRIMARY KEY on a *group* of columns imply that each