unique and null values

2001-07-19 Thread Aek
back to my unique constraint again :) i asked on irc but couldnt get anything out of them so i came here. got a unique constraint with serveral columsn like so.. UNIQUE (col1,col2,col3) id like to have col2 and col3 to use null values but it doesnt seem to like this. Is there a way i can use co

unique and null values

2001-07-12 Thread Aek
back to my unique constraint again :) i asked on irc but couldnt get anything out of them so i came here. got a unique constraint with serveral columsn like so.. UNIQUE (col1,col2,col3) id like to have col2 and col3 to use null values but it doesnt seem to like this. Is there a way i can use co