Thanks for helping out. I’ll update the patch.
Reinier Van: Walter Cruz [mailto:[EMAIL PROTECTED] Verzonden: zondag 6 april 2008 18:05 Aan: Reinier Balt CC: [email protected] Onderwerp: Re: [Tracks-discuss] problem with postgres and version Hey, in fact, your last query works. Sorry for the misinformation on the previous email :D []' - Walter On Sun, Apr 6, 2008 at 1:02 PM, Walter Cruz <[EMAIL PROTECTED]> wrote: 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
