Re: Having a 2-column uniqueness constraint - Mailing list pgsql-general

From Shridhar Daithankar
Subject Re: Having a 2-column uniqueness constraint
Date
Msg-id 3F1DAD65.24861.695E9C@localhost
Whole thread Raw
In response to Having a 2-column uniqueness constraint  (VanL <vlindberg@verio.net>)
List 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.


pgsql-general by date:

Previous
From: VanL
Date:
Subject: Having a 2-column uniqueness constraint
Next
From: Bruce Momjian
Date:
Subject: Re: [BUGS] INSTEAD rule bug?