Received: from mx1.landsraad.net (chusuk.arrakis.es [195.5.65.35]) by hub.org (8.8.8/8.7.5) with ESMTP id SAA22758 for ; Mon, 15 Jun 1998 18:03:36 -0400 (EDT) Received: from maniac.ddns.org (if-26.arrakis.es [195.5.75.26]) by mx1.landsraad.net (8.8.6/8.7.3) with ESMTP id AAA23817 for ; Tue, 16 Jun 1998 00:01:07 +0200 (MET DST) Received: (from root@localhost) by maniac.ddns.org (8.9.0/8.9.0) id AAA01080 for pgsql-sql@postgreSQL.org; Tue, 16 Jun 1998 00:01:22 +0200 Message-ID: X-Mailer: XFMail 1.3 [p0] on Linux X-Priority: 3 (Normal) Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit MIME-Version: 1.0 Date: Tue, 16 Jun 1998 00:01:21 +0200 (CEST) Organization: Maniac, Ltd. Sender: root@maniac.ddns.org From: Josep Carles Collazos To: pgsql-sql@postgreSQL.org Subject: Unique index on non-erased values I have a table with users in this manner: create table users ( id char(8) not null, active boolean, erased boolean ) I wat to ensure that the id is a unique index but only among the non-erased users (Those who erased is false). Someone can help me ? An other question. PostgreSQL supports constraints ? Can I simulate constraints of some manner ? thx