Timeline for conditional unique constraint
Current License: CC BY-SA 2.5
2 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 15, 2009 at 13:44 | comment | added | D. Patrick | That's actually pretty clever Carl. It's not an answer to the question per se, but it's a good solution. If the table has a lot of rows, that could also speed up looking for an active record because you could look at the active record table. It would also speed up the constraint because the unique constraint uses an index as opposed to the check constraint I wrote below which has to execute a count. I like it. | |
| May 14, 2009 at 22:01 | history | answered | Carl Manaster | CC BY-SA 2.5 |