[Dbix-class] Re: how to use a complex query in DBIx::Class

[Jess Robinson]

On Wed, 27 Dec 2006, A. Pagaltzis wrote:

> * Brandon Black <blblack at gmail.com> [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=FF=FFt 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=FF=FFt even see how that boolean expression
> would ever be false, given the `userId =3D '3'` condition.
>
>> I don't see what any of it has to do with your vat example.
>
> Jess=FF=FF =FF=FFI=FF=FFve not seen this syntax=FF=FF seemed to refer to =
the use of
> expressions in the SELECT clause. I=FF=FFm not sure it does, or if I
> misunderstood Jess; nor am I sure Jess whether misunderstood the
> query or not; the only thing I=FF=FFm sure of is I still don=FF=FFt
> 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