I still think one shouldn't allow NULL values in unique constraints
unless it's the _only_ value (any value is unique if there are no other
values to compare with, after all), but I can't compare myself to
C.Date, Darwen or Tom Lane... I'm not a database deity :P
You can not declare a uniq
Alban Hertroys <[EMAIL PROTECTED]> writes:
> I suspect they have some pretty good reasons to treat NULL values in a
> UNIQUE constraint as different even from other NULL values. It sure
> makes me curious though ;)
Date & Darwen make it pretty clear that they think this sucks, and in
fact that t
Vivek Khera wrote:
On Feb 16, 2006, at 6:27 AM, Alban Hertroys wrote:
Vivek Khera wrote:
http://dev.mysql.com/doc/refman/5.1/en/bdb-restrictions.html
I especially like the third restriction. How on earth do people
live with this software?
That's the part where they allow only one NULL
Alban Hertroys <[EMAIL PROTECTED]> writes:
> But according to:
> http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@Generic__BookTextView/21064
> "The definition of unique constraints in the SQL standards specifies
> that the column definition shall not allow null values.", although t
On Feb 16, 2006, at 6:27 AM, Alban Hertroys wrote:
Vivek Khera wrote:
http://dev.mysql.com/doc/refman/5.1/en/bdb-restrictions.html
I especially like the third restriction. How on earth do people
live with this software?
That's the part where they allow only one NULL value in a unique
i
Alban Hertroys wrote:
Vivek Khera wrote:
http://dev.mysql.com/doc/refman/5.1/en/bdb-restrictions.html
I especially like the third restriction. How on earth do people live
with this software?
That's the part where they allow only one NULL value in a unique index,
right? Opinions seem to di
Vivek Khera wrote:
http://dev.mysql.com/doc/refman/5.1/en/bdb-restrictions.html
I especially like the third restriction. How on earth do people live
with this software?
That's the part where they allow only one NULL value in a unique index,
right? Opinions seem to differ on this matter...
