Interesting question.
But the reason for wanting a unique column except where (one or other condition (e.g. NULL)) is true escapes me.
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”