From: | Ron St-Pierre <rstpierre(at)syscor(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Constraint Problem |
Date: | 2003-11-03 18:35:22 |
Message-ID: | 3FA69FEA.2070405@syscor.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Tom Lane wrote:
>Ron St-Pierre <rstpierre(at)syscor(dot)com> writes:
>
>
>>I just want to constrain the ysnDefault field to only allow one TRUE
>>value for any companyID/associationID pair, with no restrictions on the
>>number of FALSES.
>>
>>
>
>You could do that with a partial unique index. There is an example
>at the bottom of
>http://www.postgresql.org/docs/7.3/static/indexes-partial.html
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
>
>
>
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
I've tried many different ALTER TABLE ... CREATE CONSTRAINT variations,
all without success.
Anyone know how?
Thanks
Ron
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-11-03 19:54:14 | Re: question |
Previous Message | javier garcia - CEBAS | 2003-11-03 18:23:27 | transposed query? |