With postgres, it doesn't work without group by
"ERROR: column "todos.id" must appear in the GROUP BY clause or be used in an aggregate function" []'s - Walter On Sun, Apr 6, 2008 at 12:57 PM, Reinier Balt <[EMAIL PROTECTED]> wrote: > Hmm, seems like the GROUP BY does not work. > > Could you try > > @down_count = Todo.count( > :all, > :conditions => ['todos.user_id = ? and todos.state = ? and > contexts.hide = ? AND (projects.state = ? OR todos.project_id IS NULL)', > current_user.id, 'active', false, 'active'], > :include => [ :project, :context ]) > > Reinier > > Van: Reinier Balt [mailto:[EMAIL PROTECTED] > Verzonden: zondag 6 april 2008 17:24 > Aan: 'Walter Cruz' > CC: '[email protected]' > Onderwerp: RE: [Tracks-discuss] problem with postgres and version > > Great, I'll add it to trunk and 1.5.1. > > Reinier > > Van: Walter Cruz [mailto:[EMAIL PROTECTED] > Verzonden: zondag 6 april 2008 17:22 > Aan: Reinier Balt > CC: [email protected] > Onderwerp: Re: [Tracks-discuss] problem with postgres and version > > Yes Reinier, this query works well :) > > I will patch my tracks instance :D > > []'s > - Walter > >
_______________________________________________ Tracks-discuss mailing list [email protected] http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss
