> --- Richard Broersma Jr <rabroersma@yahoo.com> wrote:
>
>> CREATE UNIQUE INDEX Only_one_row_true
>> ON Your_table ( featured )
>> WHERE featured = true;
>>
>> Or if you want to only allow 1 featured article per catagory then:
>>
>> CREATE UNIQUE INDEX Only_one_row_true_per_catagory
>> ON Your_table ( catigories, featured )
>> WHERE featured = true;
>>
>
> I forgot the unique part of the DDL.
>
> Regards,
> Richard Broersma Jr.
>
>
Thanks for the information. I will check it out and get back to you.
Thanks again,
J