Re: Having a 2-column uniqueness constraint

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Having a 2-column uniqueness constraint
Date: 2003-07-22 16:02:21
Message-ID: 3F1DAD65.24861.695E9C@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 22 Jul 2003 at 9:29, VanL wrote:
> Put another way, how can I set a (domain_name, mid) UNIQUE constraint?

Set the two fields non-NULL and create a composite unique index on them. That's
what a primary key enforces.

Bye
Shridhar

--
Newton's Little-Known Seventh Law: A bird in the hand is safer than one
overhead.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-07-22 16:02:34 Re: [GENERAL] INSTEAD rule bug?
Previous Message Vivek Khera 2003-07-22 15:52:44 Re: Checkpoint question