| Subject | unique constraint on a pair, one NOT NULL, one NULL |
|---|---|
| Author | car.toper |
| Post date | 2009-05-05T19:42:17Z |
I have a number of tables in which there are two fields:
TEXTID CHAR(10) NOT NULL,
ENDDATE TIMESTAMP NULL
I need to put a unique constraint on the system so that there can only be one row with a given TEXTID and have an ENDDATE of NULL. Interbase 7.5 is not allowing me to create such a contraint. It is possible or must it be done in triggers?
TEXTID CHAR(10) NOT NULL,
ENDDATE TIMESTAMP NULL
I need to put a unique constraint on the system so that there can only be one row with a given TEXTID and have an ENDDATE of NULL. Interbase 7.5 is not allowing me to create such a contraint. It is possible or must it be done in triggers?