On Wed Sep 19, 2007 at 12:58:24PM +0200, Mark Lawrence wrote: > SELECT > t1.id, > CASCADE(t2.lang, t1.lang) AS lang, > CASCADE(t2.title, t1.title) AS title, > CASCADE(t2.body, t1.body) AS body, > FROM > entry AS t1 > LEFT JOIN > entry_t AS t2 > ON > t1.id = t2.transof AND t2.lang = 'ru' > ORDER BY > t1.ctime > LIMIT 5
My apologies, I got the function name wrong. There is no CASCADE, the one I should have written is COALESCE. Sorry for the confusion. Mark. -- Mark Lawrence _______________________________________________ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[EMAIL PROTECTED]
