On 8/18/06, Paul Henrich <[EMAIL PROTECTED]> wrote: > It seems postgres has a strange syntax/behavior for GROUP BY that becomes > difficult to work with when using SQL::Abstract and when working with joined > tables. Basically, any column you select must be used in the GROUP BY or in > an aggregate function.
If I'm not mistaken, that is ANSI SQL syntax. MySQL allows you to select other columns without using them in the GROUP BY, but that's an extension of the standard. _______________________________________________ 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]/
