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

[Brandon Black]

On 12/26/06, A. Pagaltzis <pagaltzis at gmx.de> wrote:
> * Jess Robinson <castaway at desert-island.demon.co.uk> [2006-12-27 00:30]:
> > I've not seen the syntax "SELECT .. hiddenboards.userId IS NOT
> > NULL as hidden" .. it's odd, why not use the proper join type?
>
> You mean you've not seen this either?
>
>     SELECT price, price * 1.16 AS incl_vat FROM ... WHERE ...
>
> What does that have to do with join types?
>

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, which seems
like a hack/workaround for not using the correct join type in the
first place.  I don't see what any of it has to do with your vat
example.

-- Brandon