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
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!!? |