Re: Constraint Problem - Mailing list pgsql-general

From Greg Stark
Subject Re: Constraint Problem
Date
Msg-id 87u15l6wkr.fsf@stark.dyndns.tv
Whole thread Raw
In response to Re: Constraint Problem  (Ron St-Pierre <rstpierre@syscor.com>)
Responses Re: Constraint Problem  (Ron St-Pierre <rstpierre@syscor.com>)
List pgsql-general
Ron St-Pierre <rstpierre@syscor.com> writes:

> This is not quite what I need. I need to create a constraint to allow only
> -one- of
>     company<->association<->default(=true) value
> but any number of
>     company<->association<->default(=false) values

So a unique index on "(company,association) where default" doesn't do what you
want?



--
greg

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Constraint Problem
Next
From: Greg Stark
Date:
Subject: Re: Cartesian product bug?