Subject | Re: [firebird-support] unique constraint on a pair, one NOT NULL, one NULL |
---|---|
Author | Ivan Prenosil |
Post date | 2009-05-06T13:28:27Z |
"Helen Borrie" wrote:
(But of course it does not allow PK Constraint).
Ivan P.
> In Firebird, since Fb 1.5, it has been possible to create a unique *index* that contains a nullable key that could be null forFirebird _does_ allow Unique Constraint on nullable columns.
> only one record in the table. (If you are interested, the rules are in the Fb 1.5 release notes.) However, Firebird does not
> allow a unique CONSTRAINT that contains nullable columns, since the purpose of a unique constraint is to provide an alternative
> key for foreign key references.
(But of course it does not allow PK Constraint).
Ivan P.