Received: from localhost (unknown [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 08D809F954F
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon,  3 Sep 2007 17:40:19 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 30654-04 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon,  3 Sep 2007 17:40:13 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from web31814.mail.mud.yahoo.com (web31814.mail.mud.yahoo.com
	[68.142.206.167])
	by postgresql.org (Postfix) with SMTP id 05EB99F9621
	for <pgsql-sql@postgresql.org>; Mon,  3 Sep 2007 17:40:11 -0300 (ADT)
Received: (qmail 78886 invoked by uid 60001); 3 Sep 2007 20:40:07 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
	b=g5pz9H/z/Dwuwm5/2bfkkVNfKun63kkB6OLa6j5eUb1WzjRJxGpe+kOus9i8hf/UA+DbEA/7NbVxMa6oNoctB7FHtuEIQL00E5Iymt4YzzP064HcZvA4NPepWurd/YZtt6BPpeF9q8vIfg+CBG0RPLpgUh4PtCip53O5/nxxd1w=;
X-YMail-OSG: 
 E7b1QygVM1mE8udQ5vKd4sIDyhB8wOb7NPiKbqUFrPTDqivOQUEmafwMnJt2uM7ymwFM7w--
Received: from [65.211.203.27] by web31814.mail.mud.yahoo.com via HTTP;
	Mon, 03 Sep 2007 13:40:06 PDT
Date: Mon, 3 Sep 2007 13:40:06 -0700 (PDT)
From: Richard Broersma Jr <rabroersma@yahoo.com>
Subject: Re: Constraints for grouping
To: Richard Broersma Jr <rabroersma@yahoo.com>,
	PostgreSQL Admin <postgres@productivitymedia.com>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <602367.49974.qm@web31801.mail.mud.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <917951.78388.qm@web31814.mail.mud.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200709/12
X-Sequence-Number: 29225

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.