On Wed, 27 Dec 2006, A. Pagaltzis wrote:
* 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.
I was referring to the IS NOT NULL in the SELECT part of the query.. I
dont see what its doing / supposed to do at all. Care to explain what that
is doing?
Jess
_______________________________________________
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]/
