Re: Constraint Problem

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Constraint Problem
Date: 2003-11-03 20:12:04
Message-ID: 87u15l6wkr.fsf@stark.dyndns.tv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ron St-Pierre <rstpierre(at)syscor(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Stark 2003-11-03 20:21:58 Re: Cartesian product bug?
Previous Message Martin Hart 2003-11-03 20:00:48 C functions quicker than Plpgsql?