On Fri, 18 Aug 2006, Paul Henrich wrote:
> On Aug 18, 2006, at 3:55 PM, Brandon Black wrote: >> >> On 8/18/06, Paul Steinkamp <[EMAIL PROTECTED]> wrote: >> Greetings, >> >> Can't the same effect be achieved with GROUP BY? >> >> -- Brandon > > I just ran into this myself. > > 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. In my case I was (fortunately) able to simplify things > by just by setting distinct => 1. Strange behaviour? That's quite normal and sane.. /me curses DBs that teach people non-ansi rubbish. Jess _______________________________________________ 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]/
