jeudi 10 mars 2016

sqlite CHECK condition, rowitems have to differ

I am wondering if there is any query that checks if all of the entries in a row are differing.

table family
familyID   familyMember1   familyMember2 ... familyMember4

Instead of checking familyMember1 != familyMember2 , familyMember1 != familyMember3, ... familyMember3 != familyMember4, I want to implement a shorter check constraint. Is there a way to do this?

Thank you for your help.

Aucun commentaire:

Enregistrer un commentaire