On 8/18/06 4:59 PM, Mark Blythe wrote: > On 8/18/06, John Siracusa <[EMAIL PROTECTED]> wrote: >> Now guess what value c will have in the row returned by this query: >> >> SELECT a, SUM(b), c FROM t GROUP BY a; >> >> Good old MySQL... > > Sure, the columns you select must have unique values per group. That > limitation used to be stated in the MySQL docs.
Now if only that requirement could be enforced somehow...maybe by, oh, I don't know, the database software or something. -John _______________________________________________ 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]/
