partial unique constraint
От | Robert Treat |
---|---|
Тема | partial unique constraint |
Дата | |
Msg-id | 1081261772.31785.48.camel@camel обсуждение исходный текст |
Ответы |
Re: partial unique constraint
Re: partial unique constraint Re: partial unique constraint Re: partial unique constraint Re: partial unique constraint Re: partial unique constraint |
Список | 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
В списке pgsql-sql по дате отправления: