Subject | Feature request: Changes in Unique constraint / Unique Index |
---|---|
Author | Trond |
Post date | 2004-08-30T23:36:28Z |
Feature request: Changes in Unique constraint / Unique Index
From the manual:
The constraint allows existence of only those rows for which the
aforementioned <search condition>
evaluates to True. In a unique index or under a UNIQUE constraint, two
sets of column values will be
considered distinct and thus allowed if:
a) both sets contain only nulls, or
b) there is at least one pair of corresponding values of which one is
non-null, and the other either null
or a different non-null value.
.
.
.
What I would like is that two or more sets of column values will be
considered distinct and thus allowed if: at least one contains nulls.
After all isn't it safe to say that (1,null) is distinct from (1,null) as
long as null is distinct from null ?
best regards
Trond.
--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
From the manual:
The constraint allows existence of only those rows for which the
aforementioned <search condition>
evaluates to True. In a unique index or under a UNIQUE constraint, two
sets of column values will be
considered distinct and thus allowed if:
a) both sets contain only nulls, or
b) there is at least one pair of corresponding values of which one is
non-null, and the other either null
or a different non-null value.
.
.
.
What I would like is that two or more sets of column values will be
considered distinct and thus allowed if: at least one contains nulls.
After all isn't it safe to say that (1,null) is distinct from (1,null) as
long as null is distinct from null ?
best regards
Trond.
--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/