Re: partial unique constraint
От | Robert Treat |
---|---|
Тема | Re: partial unique constraint |
Дата | |
Msg-id | 1081269521.31791.73.camel@camel обсуждение исходный текст |
Ответ на | Re: partial unique constraint (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: partial unique constraint
|
Список | pgsql-sql |
On Tue, 2004-04-06 at 11:17, Tom Lane wrote: > Robert Treat <xzilla@users.sourceforge.net> writes: > > Trying to come up with the proper syntax to meet the following criteria: > > create table foo (bar integer, baz boolean UNIQUE (bar, baz = true)); > > The correct way to do it is with a separate CREATE INDEX command: I think I had initially abandoned looking at that type of solution after having run across this paragraph in the docs while looking for the proper constraint syntax: "Note: The preferred way to add a unique constraint to a table is ALTER TABLE ... ADD CONSTRAINT. The use of indexes to enforce unique constraints could be considered an implementation detail that should not be accessed directly." The subliminal mind is a powerful force eh? Perhaps that paragraph should be modified... but I'm not sure if it should expanded to include thoughts along the lines of Stephan's response or maybe just drop the "should not be accessed directly" bit... Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
В списке pgsql-sql по дате отправления: