Keith,
Good point. Did not know this exists.
Ken
On 01/10/2017 09:48 PM, Simon Slavin wrote:
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
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
