On 1/31/07, Matt S Trout <[EMAIL PROTECTED]> wrote:
Actually, I said that many-many is a bridge across two relationships and that we needed to cover the general case of that in terms of the result_source level infrastructure, including providing metadata.
So here is an example for the general case, perhaps you could call it a bit ephemeral (it might be used in a model for the [user, item, tag] trio optimalised for some queries) - but I hope it is at least amusing: select * from a, b, c where a.key1 = b.key2 and b.key1 = c.key2 and c.key1 = a.key2 With composed (key1, key2) primary keys for a, b and c tables. This join is a three table relationship (just like the many to many case) - and I think it is not reducible to a superposition of two table relstionships (differently from the many to many case). To reiterate - I did read your thesis that many to many is not a relatioship - so you don't need to repeat that - I am just asking why it is not and what is a relatioship. -- Zbyszek _______________________________________________ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class Wiki: http://dbix-class.shadowcatsystems.co.uk/ IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ Searchable Archive: http://www.mail-archive.com/[email protected]/
