partial unique constraint

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: partial unique constraint
Date: 2004-04-06 14:29:32
Message-ID: 1081261772.31785.48.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Trying to come up with the proper syntax to meet the following criteria:

create table foo (bar integer, baz boolean UNIQUE (bar, baz = true));

note the above syntax is not correct, but should demonstrate what i'm
trying to do; I want to add a unique constraint such that we only allow
one case of bar and baz = true... i can have unlimited bar and baz =
false, and there can be multiple bar and baz = true if the bars are
different... did some doc reading and mail list searching but a valid
syntax for this seems to be escaping me...

btw I'm pretty sure I could do this with an external trigger, but am
wondering about a constraint oriented approach

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-04-06 15:00:52 Re: could not devise a query plan
Previous Message Jeff Eckermann 2004-04-06 14:27:34 Re: Entered data appears TWICE in table!!?