On 11 Jan 2017, at 1:02am, Keith Medcalf <kmedc...@dessus.com> wrote:
> You are correct, however, if there were a unique constraint placed on > tracks.name, then a given track could only appear once (in the first case), > or in multiple places (in the second case). _The Power of Love_ was recorded by Frankie Goes to Hollywood, Jennifer Rush, and Huey Lewis and The News. Not only are these different recordings, they’re different songs. Nor can you place a UNIQUE requirement on the combination of (title,authors). There are three different /studio/ edits of Bowie’s _Heroes_, and two of them are different enough that someone might like one and not the other. Not to mention numerous different live versions which appear on convert albums and DVDs. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users