lay with this a bit to
understand how it works. Thanks for the tips!
Phill
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Sat 4/29/2006 3:02 PM
To: Bruno Wolff III
Cc: Jeff Frost; Tornroth, Phill; pgsql-sql@postgresql.org
Subject: Re: [SQL] Multi-Column Constraints
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> To block multiple entries where one of the columns is null he needs to
> add extra checks. One way to do this is to add a partial index for each column
> with the condition that the other column IS NULL. This will cover everything
> but the case where b
On Sat, Apr 29, 2006 at 13:14:36 -0700,
Jeff Frost <[EMAIL PROTECTED]> wrote:
> On Thu, 27 Apr 2006, Phillip Tornroth wrote:
>
> >I have a problem in a number of my tables. I'd like to add uniqueness
> >constraints across multiple columns, but some of the columns are nullable.
> >This gives me
On Thu, 27 Apr 2006, Phillip Tornroth wrote:
I have a problem in a number of my tables. I'd like to add uniqueness
constraints across multiple columns, but some of the columns are nullable.
This gives me trouble since when I create a constraint on columns A and B..
I'd like the constraint to b
I have a problem in a number of my tables. I'd like to add uniqueness
constraints across multiple columns, but some of the columns are
nullable. This gives me trouble since when I create a constraint on
columns A and B.. I'd like the constraint to be enforced such that
you couldn't insert v
