On 12/26/06, A. Pagaltzis <[EMAIL PROTECTED]> wrote:
* Jess Robinson <[EMAIL PROTECTED]> [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 _______________________________________________ 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]/
