Re: Constraints for grouping

OOPS!
--- 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.