Re: Constraints for grouping - Mailing list pgsql-sql

> --- 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