OOPS!
--- Richard Broersma Jr <rabroersma(at)yahoo(dot)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.