Greg Stark wrote:
>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
>>>>>>
>>>>>>
>
>
>
>>I then checked::
>> planrrontest=# SELECT * FROM compass WHERE company=23590;
>> compassnid | company | association | ysndefault
>> ------------+---------+-------------+------------
>> 7777 | 23590 | 4 | t
>> 8038 | 23590 | 2 | t
>> 8040 | 23590 | 7 | t
>> (3 rows)
>>
>>And as you can see company 23590 has three default associations. Any ideas on
>>how I can get around this?
>>
>>
>
>But they're all different associations. If you reread your original question
>above you'll see that's not what you described. You said you only wanted one
>of any <company,association,default> value when default is true.
>
>Try just
>
>create unique index on compass (company) where ysndefault
>
>
You're right, I was trying to associate the company-association-default
where default=TRUE, when I didn't need the association as part of it at
all. It's working now, thanks. I'll now try to find my way out of
'Monday morning mode'.
Thanks all
Ron