Re: [SQL] Table Constraints with NULL values

2001-10-19 Thread David Allardyce
hey meant what you want the behavior to > be, ISTM they'd have defined uniqueness constraints by saying "all the > rows must be distinct". > Actually, I don't think the definition of distinct is a contradiction at all. Instead, I think it explains why they specifically exc

[SQL] Table Constraints with NULL values

2001-10-18 Thread David Allardyce
VARYING(100) NULL DEFAULT NULL, arg3CHARACTER VARYING(100) NULL DEFAULT NULL, CONSTRAINT unique_aofunction UNIQUE (name, skill, arg1, arg2, arg3) ); David Allardyce ---(end of broadcast)--- TIP 3: if posting/reading through Usenet