* Brandon Black <[EMAIL PROTECTED]> [2006-12-27 01:05]: > She was referring to the odd use of selecting the boolean NOT > NULL of what seems to be the pk in a foreign table being > joined
Ah, I didn’t notice the condition in the ON clause (which should have been in the WHERE clause anyway). > which seems like a hack/workaround for not using the correct > join type in the first place. Looking again now I can’t even see how that boolean expression would ever be false, given the `userId = '3'` condition. > I don't see what any of it has to do with your vat example. Jess’ “I’ve not seen this syntax” seemed to refer to the use of expressions in the SELECT clause. I’m not sure it does, or if I misunderstood Jess; nor am I sure Jess whether misunderstood the query or not; the only thing I’m sure of is I still don’t understand how that query ended up the way it is. Yeah. Regards, -- Aristotle Pagaltzis // <http://plasmasturm.org/> _______________________________________________ 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]/
