[sqlalchemy] Re: Group_by 0.4 sytax

2007-12-18 Thread Michael Bayer
On Dec 18, 2007, at 9:49 AM, voltron wrote: I am trying to retrieve unique users from a table using this: results = sa_session.query(TempScore).group_by(TempScore.user_name) This unfortunately causes the error below: There was a problem: (ProgrammingError) column temp_scores.id must

[sqlalchemy] Re: Group_by 0.4 sytax

2007-12-18 Thread voltron
Thanks! I'll try that out Mike On Dec 18, 3:55 pm, Michael Bayer [EMAIL PROTECTED] wrote: On Dec 18, 2007, at 9:49 AM, voltron wrote: I am trying to retrieve unique users from a table using this: results = sa_session.query(TempScore).group_by(TempScore.user_name) This unfortunately